Removed security - not have issues

[Jaye7]

I am using Access 2010 and I removed the Admin password and now when I open a database I get a message like you do not have necessary permission to us the X;\Jobs_2002_be.mdb' object

How do I fix this, as when I log on to a different database I then get a message saying record(s) cannot be read; no read permission on 'Lab - Employees'.

Also get message when trying to open a table in the database saying - could not read definitions; no read definitions permission for table or query Lab - Employees

Does this mean that I have to also delete the user groups and only have Admin, so that the errors don't come up and would this be required for each database that has security settings.

 

[gemma-the-husky]

you should not mess with system.mdw (the standard "rights" file)

you should create a new mdw file and secure your database(s) against this.

Be careful, you may permanently lock yourself out of all your database.(s).

To solve your current problem, you could try to find system.mdw (somewhere in c:\windows), and rename it systemx.mdw (say). Access MAY create a new default system.mdw file for you, which MAY fix the issue.

Before you use Access ULS, make sure you understand exactly what it is saying. It is not easy to use, and as I say, easy to lock yourself out of your databases.

Just creating a mdw file with the correct name is not enough. You also need to know the credentials you used to create the mdw file. (or at least make sure you have copies of the mdw files stored safely.)

certainly do not delete anything from your mdw file until this sorted. Hopefully it isn't already too late.

 

[Jaye7]

Thanks Dave,

No, I haven't touched the mdw file at this stage.

I was going to remove the admin password (which tried, then reset back) and then create new databases and import the objects from the old into the new as reading up on the mdw it seems that many people have had issues, whereas the problem seems to be avoided if you just remove the password and create new databases.

As I haven't done this before though, maybe what I have read is wrong.

I will find out once I try it in the near future, but I will back everything up first.