Access to DB lost

  • Thread starter Thread starter chuckmg
  • Start date Start date
C

chuckmg

I am the Administrator, user, owner, and creator of an access db. It also
has a WID. Used it 2 days ago. Tried to access it today and get the error msg:
You do not have the necessary permissions to use the xxx.mdb object. Have
your system administrator or the person who created this object establish the
appropriate permissions for you.

What do I do now??
 
Chris,

I created a shortcut with target:
"C:\Program Files\Microsoft Office 2003\OFFICE11\MSACCESS.EXE"
"D:\Home\Temple\Members\Database\BetChavDB.mdb" /wrkgrp
"D:\Home\Temple\Members\Database\Access Work Group info.mdw"
and received the same error message.

Did a system search on *.mdw files and found 1, system2.mdw, created on
4/7/09. Tried using the pathname to that in the shortcut but same error msg.
Is there something I need to modify?

Chuck
 
Chris,

I was able to logon to BetCharDB.bak but, of course, non of the updates I
had done since it was created (a lot) are there. I also tried logging on as
system administrator Administrator, instead of as Chuck (who is also an
administrator and creater) but no luck.

I looked at the queries in Access Work Group info.mdw and found the
following - if it means anything):
MSysGroupList: Admins, Users
MSysGroupMembers:
prompts for GroupName
tables: MSysAccounts, MSysAccounts_1
MSysUserLst: admin, Chuck,Creator,Engine
MSysUserMemberships:
prompts for UsernName
tables: MSysAccounts, MSysAccounts_1
Criteria: FGroup <>0
Once I try to log into the db with a given login name, it no loner asks me
for UserID or Passwd.

Any more thoughts? Chuck
 
Chris,

Accessed "Access Work Group info.mdw" as you suggested. Contrary to what
you thought should be there I found the following:
There are 2 Available Groups: Admins and Users
Admin is a member of Users.
Chuck is a member of Admins and Users

Opened Access without a shortcut and found Groups and Users the same as
above. Are the ID's case sensitive?

Did not find any other mdw files.

Chuck
 
Chris,

Now I am completely confused.

1. When you say to login as Chuck or Admin, are you talking about logging
into WinXP or msaccess.exe? 'Chuck' is my WinXP userID and a BetChavDB.exe
user and Admins ID. 'Administrator' is my WinXP Administrator ID. I have
no idea what 'Admin' is except that it is obviously a BetChavDB.mdb user.

2. I can't try to login to msaccess.exe as Admin since I don't know how to
get msaccess.exe to log Chuck out.

3. When I use the shortcut to "C:\Program Files\Microsoft Office
2003\OFFICE11\MSACCESS.EXE" /wrkgrp "D:\
Home\Temple\Members\Database\Access Work Group info.mdw", OR access BetchavDB.mdb directly, I can't add any user to either group, Admins or Users.
Click to expand...

Chuck
 
Back
Top