Ad:

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

by rhenerlau on Apr 22nd, 2005

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.

Visual Basic 4 / 5 / 6 Code Snippet (Toggle Plain Text)

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"
=====================================================

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: tranmit sound

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: code to validate data in Access withOUT using messageboxes

DaniWeb Message

Cancel Changes

User Name
Password