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.

rhhuntAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rhhuntAuthor Commented:
na
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Sounds like you need to WorkGroup file (.MDW) that goes with the A2003 secured db.  Do you have that?

mx
0
rhhuntAuthor Commented:
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 ?  
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Well, I'm not really the ULS expert .... LSM will probably be by shortly ...

mx
0
rhhuntAuthor Commented:
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.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"I do not know any of the other defined user ids or the passwords. "
So, you did not create this database ?

mx
0
rhhuntAuthor Commented:
Exactly, have inherited support of this mess.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Well, unfortunately as we have no way of knowing if you are authorized to work with this db, we cannot advise you how to ...  what amounts to ... hacking into the db.   You need to get the original secured information.

Sorry ...

mx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rhhuntAuthor Commented:
Yes can see your point, thanks for the info anyway.  Today has been a long education.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
EE Rules ...

mx
0
rhhuntAuthor Commented:
No expert would help as they could not be sure I was not trying to hack the db.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.