read only database

[Steve]

I have an access mdb database that was created by another user who is no
longer with the company. I believe it was created with Access 2000 and I am
using 2003 to open it. It works fine but will not allow me to add any new
records. I have full rights to the folder but when I go to insert a new
record it is greyed out and the tools menu is not displayed at the top. How
can I open it in design view to edit it and add records?

 

[Joan Wild]

I have an access mdb database that was created by another user who is no
longer with the company. I believe it was created with Access 2000 and I
am
using 2003 to open it. It works fine but will not allow me to add any new
records. I have full rights to the folder but when I go to insert a new
record it is greyed out and the tools menu is not displayed at the top.
How
can I open it in design view to edit it and add records?

Adding new records - check the allow additions property for that form; check
that the recordsource (if it's a query) is updateable i.e. can you open the
query and update it?

Getting full menus: Try holding down the shiftkey while you open the
database. If that doesn't work, it may have been disabled. Try Albert
Kallal's utility to re-enable the shiftkey bypass.

 

[Joan Wild]

Sorry, forgot the URL
http://www.members.shaw.ca/AlbertKallal/msaccess/shiftkey2000.zip