Re: Old Question, new twist: No read definitions

Tech-Archive recommends: Fix windows errors by optimizing your registry

"DissentChick" <DissentChick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6686EA33-41D5-4CAF-AC67-C6E1D4F2B763@xxxxxxxxxxxxxxxx
> Hi, I tried to post this earlier, but am not sure itwent thru, so I
> apologize
> if it is duplicate

It did come through. See my answer there.

- I was configuring security settings in my db, and forgot
> to go into exclusive mode beforehand.

You don't need to open it exclusively to configure security.

> I was under the Admin name when doing

Do you mean you were logged in as 'Admin' or logged in as a member of the
Admins Group?

> the changes, and now everytime I try to open a table, etc., I get the
> message
> "No read definitions.." and/or "Could not read definitions or
> permissions."

You need to log in as the user that is a member of the Admins Group. Also
ensure you are using the correct mdw file.

> I have tried to go under other users ( who did not
> yet have passwords set) and at startup, the password prompt doesn't even
> come
> up

That suggests that you aren't using the correct mdw, but instead the
standard system.mdw that ships with Access.

- It goes straight to the database window.

And that suggests to me that if you are using the system.mdw then it isn't
secured properly.

Did I accidently lock out the
> admin? Is there a way to get back Admin priveleges? BTW, this db is only
> on
> my machine. Thanks so much for any help in advance-

Use Start, Run, wrkgadm.exe to see what workgroup you are joined to by
default (post back with this).

What is the name of the mdw file that you secured the mdb with?

--
Joan Wild
Microsoft Access MVP


.

Relevant Pages

  • Re: Lost Permission
    ... I set a password for the Admin User. ... "Joan Wild" wrote: ... Therefore you get no login prompt. ... >>> Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: Lost Permission
    ... that means that the password for the 'Admin' user has been set to ... Close Access and try your shortcut again, ... > "Joan Wild" wrote: ... >> Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: New Post - Owner deleted - No backups, nothing!
    ... Microsoft Access MVP ... "Graham R Seach" wrote: ... order to discover the Admin password. ...
    (microsoft.public.access.security)
  • Re: Temprarily locking out other users?
    ... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ... making changes to the table of staff/users -- about ... after the form is opened and while the admin is in the process of making ...
    (microsoft.public.access.modulesdaovba)
  • Re: Need a totally READ ONLY database
    ... I thought that limiting the permissions to the "Users" group ... > group of which Admin is also a member - which can't be revoked. ... Then, regardless what MDW file ... >> Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.security)