User groups and permissions

  • Thread starter Thread starter JoeBlack
  • Start date Start date
J

JoeBlack

Hi all,

I have an access database named altera.mdb, a user had a problem with it the
other day and now it gives the error:

Could not read definitions; no read definitions permission for table or
query 'Passwords'

Now I would normally set the permisions by going to Tools->Security->User
and Group Permisions

select the relevant table, and check the boxes marked,

Read Design
Modify Design
Administer

However when I do this and try to apply my changes I get the following
error:

You can't change permissions for 'Passwords'

To change permisions for this object, you must have Administer permision for
it. For more information on permisions and who can set them, click help.

If I refer to a really old copy of the database (the original one with test
data in it) I can change permisions on the table no problem, so I thought I
would just restore an old backup of the data base and leave it at that,
unfortunately all the backups that have been made by the user have exactly
the same problem.

Does any one know what has caused this and how to fix this?

Many thanks

Joe
 
A couple ideas here.

You could try to apply an older version of your system.mdw
file that may contain the user ID and password that you
had used at a time when you may have had administration
rights.

You could open the "Test" database and import all of the
current objects into it.

If the owner is Admin, you can TRY to log on using "Admin"
with a blank password and assign the rights as you wish
 
Thanks Bob,

I created a new database and imported all but the Passwords table, then
recreated it manually and all is calm again.

Joe
 
Back
Top