secured and unsecured dbase on pc

[Guest]

I've got a secured database on my pc and I've also got another database on my
pc that should be unsecured but when I joined the workgroup to secure the
secured dbase it also defaulted the other dbase to prompt for user/password.
How can I keep the security on the secured dbase while removing the unsecured
dbase workgroup file?

 

[Joan Wild]

Access always uses a mdw file. Keep your computer joined by default to the
standard system.mdw that ships with Access. Create a desktop shortcut for
your secure mdb - use the shortcut to open the secure mdb. All other
sessions will use the system.mdw and require no login.

The target of the shortcut would be
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure .mdw"

 

[Guest]

It's me again. Here is the path I included in the shortcut on my desktop
(I'm running Access 2003):

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" C:\Documents and
Settings\All Users\Application Data\Vehicle Database\mgcvdb.3.13.07.exe.mde"
/wrkgrp "\\Mgcjaxnn\Vehicle Database\vehiclesecurity.mdw"

First part is where MSACCESS.EXE is on my pc.
Second part is where I'll store the executable on each persons pc (and mine).
Third part is where the security file is on the server.

I' getting an error message that says:

"The Command line you used to start Microsoft Office Access contains an
option that Microsoft Office Access doesn't recognize"

 

[Guest]

Never mind. I apparently forgot a " before the C:\Documents and Settings.