Re: Permissions problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Geoff Taylor (Geoff.Taylor_at_iinet.net.au)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 21:04:41 +0800

Arthur...
Access2002
Mdb is Access2000

I have the exact same problem

I have a backend mdb file that has been in use for some time.
I opened the security menu to investigate.
Now all users, including me, get the same error message that Arthur has
described..

I have never had to deal with 'workgroup' or 'user' permissions in the
current Novell environment.
The database has never had passwords nor permissions set.

I am effectively locked out of my own database.
This is despite me having created the mdb and being the admin.

This is an urgent problem. Whilst I have a backup from earlier in the day,
users have updated the backend since then and if I drop back to that
version, data will be lost.

"Arthur" <Arthur@discussions.microsoft.com> wrote in message
news:8FD0E9C6-7A06-4A65-8B56-C1B9A9BC4521@microsoft.com...
> I am the owner/administrator/user of a mdb file. I must have boobed but I
> wanted to change the security of the macros in that particular file so
that
> it would open always without prompting. Now I cannot open the file at
all.
> I get the error message "You do not have permission to open this object
file.
> Get the owner or administrator to change the permissions to enable you to
> open the file" - or words to that effect. Hope you can assist.

Relevant Pages

  • Re: Administrator cant add users
    ... The Users Group is common to all mdw files, so normally doesn't have any permissions. ... It sounds as though someone just went in and started added usernames to the standard mdw that ships with Access. ... Are there any other Groups and/or Users when you look at Tools, Security, Accounts? ... If you start Access and create a new mdb, can you then use File, Get External Data and import all the objects from your mdb? ...
    (microsoft.public.access.security)
  • Re: Im locked out!
    ... Yes you can remove security. ... One of the wizard steps asked you if you want to backup your unsecure ... folder as your mdb, but it will have a .bak extension. ... Tools, Security, Permissions and assign all permissions on all objects ...
    (microsoft.public.access.security)
  • Re: Security schema and Split Database
    ... You should have not used the splitter wizard, ... Import all the objects from the mdb with the tables. ... Proceed to remove permissions on all objects for the Users Group, ... Security, Permissions dialog). ...
    (microsoft.public.access.security)
  • Re: Security change takes effect only locally, not on server
    ... > //UNC location of server where back end is. ... I made some changes to the security ... The permissions are stored in the mdb. ...
    (microsoft.public.access.security)
  • Re: Adding new users to an Access 2002 DB
    ... So the mdb opens when you are using the standard system.mdw. ... It sounds like someone didn't secure it properly, ... When you open it, go to Tools, Security, permissions and check to see what ...
    (microsoft.public.access.security)