access workgroup problem

[dmb1]

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!

 

[AlexMidd]

There does not appear to be a problem with the code in the shortcut, except that I think there should be quotes around the path to the actual workgroup file.

The only other thing I can think of is whether you have set up the database for exclusive use only. Alex Middleton

 

[Francescina]

Did you already check the security related articles in the ACCESS ONLINE ENCYCLOPEDIA at

http://www.unsoftwareag.com?

Good luck!