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

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
rhenerlau rhenerlau is offline Offline Apr 22nd, 2005, 3:29 pm |
0
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.
Show Printable Version Show Printable Version
Quick reply to this message  
Code Snippet
•
•
•
•
Visual Basic 4 / 5 / 6 Syntax
Toggle Plain Text
  1. General formula:
  2.  
  3. Echo off
  4. Echo Copying Database
  5. copy "Source Path" "Destination Path"
  6. start "Access Path" "Destination Path (from above)"
  7.  
  8. =======================
  9. a real example:
  10.  
  11. Echo off
  12. Echo Copying Database
  13. 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"
  14. 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"
  15. =====================================================

Quick Comment
•
•
•
•
•
•
•
•
Message:
•
•
•
•


Similar Threads
Thread Tools Search this Thread



Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 2007 access activex add age append basic beginner birth bmp c++ calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver struct subroutine tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC