read only database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Steve said:
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?
Click to expand...

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.
 
Back
Top