Joining a wrkgrp

[dgoold]

I am having a problem joining a wrkrgp .MDW file over the network using the commmand line option from a short cut on computer. The database is split with all forms etc is on workstation and tables are on network server. I tried using UNC Path after wrkgrp switch [C:\dbName.mdb /wrkgrp \\Servername\floderName\Security.mdw] Is the reason I am having problems joing is because I split database and if so will I have to put Security.mdw file I created on each workstation then update each one when I make changes

 

[ghudson]

I recommend that you keep a local copy of the .mdw file where the front end is. Give the users an updated copy of the .mdw file each time you update their local copy of the front end. I have seen many posts where there were locking issues with a split db and many were resolved once they moved the .mdw from the network and gave each user a local copy.

"C:\Program Files\Microsoft Office\Office\msaccess.exe" /wrkgrp "C:\Test\WorkGroup.mdw" "C:\Test\Frontend.mdb" /user UserName

HTH