code to split (and reconnect) an Access database (part 2) UserPageVisits:142 active 80 80 DaniWeb 561 60 2005-04-23T00:29:44+00:00 https://www.daniweb.com/programming/software-development/code/216509/code-to-split-and-reconnect-an-access-database-part-2

code to split (and reconnect) an Access database (part 2)

rhenerlau

Place the file with part one of the code on the server. This part of the code gets placed in a batch file (text file with the extension *.BAT) and placed on each client's machine. Again, you will need to change the paths used to the real paths on your network. This will get a fresh copy of the front end each time the database is launched in this method - all revisions saved to the MDE file on the server will be reflected the next time a user launches the file in this method.

142 Views
About the Author
code snippet
General formula:

Echo off
Echo Copying Database
copy "Source Path" "Destination Path"
start "Access Path" "Destination Path (from above)"

=======================
a real example:

Echo off
Echo Copying Database
copy "G:\Richard's Work\License Keys Front End.MDE" "c:\Documents and Settings\Family.Avalon2\My Documents\Richard's Work\License Keys Front End.MDE"
start "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "c:\Documents and Settings\Family.Avalon2\My Documents\Richard's Work\License Keys Front End.MDE"
=====================================================
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.