2003 MS Access - Need Table Administer Permission
Have an Access 2003 db which I am processing with Access 2010. What I want to do is add some rows to the end of an existing table. However there does not appear to be permission to do that. THe Insert button has been grayed out.
Am opening the db while holding down the Shift key, Then when I go to the File tab on the ribbon and choose Manager Security for Users and Groups I select the file and notice that all maint opions (Insert, Delete, etc) are grayed out. When I try to click these permissions for the table to allow an Insert the message is display like "To Change permissions for this object you must have Administir permissison for it.
So how do I modify the tabes which need update access ? How can I get this Administir access going for this table. Need to add data to the end of an existing data file today.
Am opening the db while holding down the Shift key, Then when I go to the File tab on the ribbon and choose Manager Security for Users and Groups I select the file and notice that all maint opions (Insert, Delete, etc) are grayed out. When I try to click these permissions for the table to allow an Insert the message is display like "To Change permissions for this object you must have Administir permissison for it.
So how do I modify the tabes which need update access ? How can I get this Administir access going for this table. Need to add data to the end of an existing data file today.
Sounds like you need to WorkGroup file (.MDW) that goes with the A2003 secured db. Do you have that?
mx
mx
ASKER
Yes in the folder where this Access db is located I have a related .MDW file. Have never worked with any of this before so give me the layman's version. What should I do now ?
Well, I'm not really the ULS expert .... LSM will probably be by shortly ...
mx
mx
ASKER
Okay did some reading and found how to create a shortcut which launces the Access db using the .MDW file. THe problem is that while they setup a Guest account which does not have a password I do not know any of the other defined user ids or the passwords. So now I can open the db using the .MDW but still cannot set the tables to allow Inserts.
"I do not know any of the other defined user ids or the passwords. "
So, you did not create this database ?
mx
So, you did not create this database ?
mx
ASKER
Exactly, have inherited support of this mess.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes can see your point, thanks for the info anyway. Today has been a long education.
EE Rules ...
mx
mx
ASKER
No expert would help as they could not be sure I was not trying to hack the db.
ASKER