Access_Newbie_2
Registered User.
- Local time
- Today, 07:22
- Joined
- Sep 7, 2003
- Messages
- 13
I have a dB that will be stored on 2 computers....Main computer #1 and a backup copy on Computer #2... These computer are not networked but are located in the same office. Now On Computer #1 the dB will be located [C:/OZRentals/OZRentals.mdb] AND at [C:/Temp/OZTemp.mdb] Users will access the OZRentals.mdb to search and/or add records and make changes to the dB. I need a code statement that will Export 3 tables [Main, Properties, & Landlords] from the Main db to the Temp dB. Then i will use a batch file [copy C:/Temp/OZTemp.mdb A:/OZTemp.mdb] then the user will take the floppy to computer #2 and on there they will have a batch file that [copy A:/OZTemp.mdb C:/Temp/OZTemp.mdb] then i will need a code that will import those same 3 tables to the Main dB replacing the current tables information so the backup copy will then be current with the front office copy. Anyone can think of an "Easy" way to accomplish this as I am not fluent with coding? I have heard about Briefcase Synchronization or something like that that only records the changes but have been unable to find much information on it... Thanks for any help you can offer!