Multiple databases logon problem

  • Thread starter Thread starter Lynn
  • Start date Start date
L

Lynn

I have multiple access databases on my PC; two original ones with no
security, one new one that I added security in preparation for moving it to
an office environment. At first I couldn't get into the old ones; now I
can't get into the new one.. It says that I don't have the permissions,
although I had put myself in the admins group, and am on as the
administrator of my PC. I have moved the databases into separate folders,
so that the security, schema files are only in the new db folder. I'm
afraid that the problem might be in the registry. Help!!

Lynn
 
You are not joined to the proper workgroup file. The two "unsecured"
databases were created while you were in the default system.mdw file ... the
new secured db was apparently created while you were joined to a different
workgroup file. FYI, Access ALWAYS uses security, even if you haven't
implemented it. Originally, you were logging in as a user named "Admin", who
was a member of the System.mdw workgroup, which is the default workgroup
installed with Access.

You can easily switch back and forth between workgroups by using the
WorkGroup administrator ... you didn't say what version of Access you're
using, so the means to access the WGA is different for each (in Access 2000
or greater, it's on the Tools - Security menu).

Also, you can build desktop shortcuts that allow you to launch Access with
any workgroup on your computer:

"Path To MSACCESS.EXE" /wrkgrp "Path to the Workgroup File"

You can also add a "Path to your database" immediately after the first
argument and before the /wrkgrp switch, if you want open a specific database
with this shortcut.
 
Back
Top