I have a database which I have setup a workgroup file for which all works fine. I have removed all admin privlidges so only users who are in my new group can get into the database.
I have then split the database and kept the backend on one machine with my workgroup file with everyone else having a frontend database on their machines. I have setup a shortcut on everyones desktop which I hoped would open up the database and join my workgroup but when I open the database up from another machine I get the message:
"couldn't use "; file already in use"
Is this an error in the code I have used for the shortcut or another error? Will I have to place a copy of the workgroup file onto everyones machine to get round this problem?
The code I used fo my desktop shortcut was:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\databasefolder\DATABASE.mdb" /wrkgrp \\ntwork_01\databasefolder\dbwkgrp.mdw
Any help will be great!
I have then split the database and kept the backend on one machine with my workgroup file with everyone else having a frontend database on their machines. I have setup a shortcut on everyones desktop which I hoped would open up the database and join my workgroup but when I open the database up from another machine I get the message:
"couldn't use "; file already in use"
Is this an error in the code I have used for the shortcut or another error? Will I have to place a copy of the workgroup file onto everyones machine to get round this problem?
The code I used fo my desktop shortcut was:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\databasefolder\DATABASE.mdb" /wrkgrp \\ntwork_01\databasefolder\dbwkgrp.mdw
Any help will be great!
