user level access on specific access 2000 db?

[Chris]

Hi,

I am using Access 2000 and Windows 2000.

I have a Access database that is in a multi-user
envirnoment. I created a workgroup with all the users and
groups required. The Workgroup information file resides on
a file server in a folder that all users have access to.

I do not want users to join the workgroup completely but
only specific database. I am trying to get the /wrkgrp
switch command to work in a short cut. I have tried every
possible syntax I can think of but can't get it right.

this is the example in Access 2000 help file.
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE
\\SalesSystem\DBFiles\SalesS.mdb /wrkgrp
\\SalesSystem\DBFiles\SalesS.mdw"


if information was as follows what might the command be?
database is in S:\shared\db1.mdb
information file is in S:\shared\db1.mdw


any help is very much appreciated.

Chris

 

[Joan Wild]

Hi Chris,

I do not want users to join the workgroup completely but
only specific database. I am trying to get the /wrkgrp
switch command to work in a short cut. I have tried every
possible syntax I can think of but can't get it right.


if information was as follows what might the command be?
database is in S:\shared\db1.mdb
information file is in S:\shared\db1.mdw

"C:\pathto msaccess.exe" "S:\shared\db1.mdb" /wrkgrp "S:\shared\db1.mdw"

You put the double quotes around each path.

You'll need to change the path to msaccess.exe to that on the computer.

Also a couple of comments:

1. You can use UNC pathnames instead of counting on every computer having
S: mapped correctly. i.e.
" \\server\path\db1.mdb "

2. You should not give your mdw the same name as your mdb. I realize you
posted sample pathnames, but thought I'd flag it anyway.