Problem with Access 2003 User Security DB opening with Access 2007


D

Donna

I have a copy of a shared Access 2003 database (.mdb) which I created and
have used since 2000 with group/user level security file (system.mdb). I
have recently since moved to another company and want to use the database at
this office.

Every time I try to open it, I get the error message "You do not have the
necessary permissions to use the ‘C:\NameOfDatabase.mdb object. Have your
system administrator or the person who created this object establish the
appropriate permissions for you."

I am a little more confused now that I have read a couple of these posts
that refer to a "System.mdw" file. I believe mine has always been
"System.mdb".

How can I open this database?
I would really appreciate assistance since I spent ~ 10 years refining this
database and would love to be able to use it again.
 
A

Arvin Meyer [MVP]

You need to have the original System.mdw file (the security file, which can
have other names, but generally has the .mdw extension) from the computer
where the database was previously stored. If it was that easy to move a
database around, it wouldn't be very secure, would it? You could search for
someone one the Internet to crack your security, and there probably are
some, but without the file, it may be expensive.
 
Ad

Advertisements

D

Donna

I do have the original System.mdb file, but it does not have an .mdw
extension. It contains all the groups and individual user names. Files it
contains are MSysGroupList, MSysGroupMembers, MSysUserList and
MSysUserMemberships.

It was secure because of the way my opening macro was designed. Anyone who
was not assigned to a specific group was unable to open the database. I
removed all the permissions from the default permissions setting and moved
them to another Group.

How can I get Access 2007 to recognize the 2003 security settings and prompt
me for a logon and password?

Thanks for your help.
 
A

Arvin Meyer [MVP]

You can try joining the workgroup, which you will probably need to use an
MDW file for. Just make a copy of the file you think is correct, and change
the extension to MDW. The file you need to start it is WRKGADM.exe. Search
for it on your machine and open it. You can even join without having Access
open.

If you've converted the database to an ACCDB you no longer have security,
but I doubt that's possible unless you can log in with proper permissions.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
 
Ad

Advertisements

D

Donna

I have not converted it to an .accdb. Also, there is no wrkgadm.exe file on
my current computer. It has the Office 2007 package, so I'm guessing there
is not working group admin file in Access 2007?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top