Discussion Starter · #1 ·
Guys and girls, got a dilemna, looked for the answer in the books, online help facilities, groups etc. Here´s what I want to do. I´ve created an Access97 database which allows our daytime auditors to audit the Central Rates workgroup. Each morning at 5 am datacenter uploads a table of all the work they did that night to an Oracle table. My database will download the daily data and make it available to the auditors based upon either customer or who the rate clerk is. That´s simple enough. The problem then is, I want a macro to pull down the data ONCE a day. A simple autoexec macro would accomplish this BUT, I don´t want it run each time the database is opened. I want it to only run the very first time the dbase is opened each day. Conceivably, a user could open the database, audit a rater, then close it and come back later the same day. Loading the data twice might corrupt the existing data. So, how do I set this up to run ONCE only, and to flag it so that attempting to download the data again will not be possible? I have a couple of ideas on how to make this work but none are elegant, nor simple. Can anyone help? I have limited VB experience so would prefer a macro solution if at all possible. Thanks to all who might offer their assistance.