I bought a database about 10 years ago and still uses it. Since then we changed our address and need to update all the forms as the address is hard coded into the forms. When I tried to modify any thing it tells me I don't have the Permission. I tried to contact the programmer, but he's been out of business years ago and was unable to contact him.

How do I reset the permission on MDB? I tried Tools->Security->User/GroupPremissions and it only shows Admin user with "Read Design" checked on all object names. And if I check on any other permission it says I need administer permission.

I tried upvmsa2k.zip "Users' passwords viewer v3.2" and it shows admin user with garbled up password. Also tried MDWRecovery, but it says there's no user or password.

Your help would be greatly appreciated.

A couple of things to try.
Are you using the full version of Access on your computer or the runtime version. The runtime version will allow you operate the database but not make any changes.

If you have the full version, try this. Don't open the database using the short cut. Open Access and click on File -> open. Highlight your database then on the open button on the bottom left click on the arrow and "Open Exclusive". This may allow you to get at the reports you want to alter.

Thats the extent of my advice. If these things don't work, perhaps one of the more experinced Access programmers will give you more information.

Another approach is to create a blank db (if you have the full installation of Access) and import all the objects from the troublesome db.

The original DB came with runtime. But I'm using full version of Access97 and Access2003 in attempt to get an access to change the address.

I've also tried to open it exclusively from Access97/Access2003, with same problem. Tried to convert to Access2003 but says no permission to do so.

Tried creating a blank database, and did an import. It imported all the tables and queries, but the Forms, Reports and Macros failed to import with permission error.

Thanks.