Urgent - Save Disabled

[Jim Bunton]

I have Access 97 & Access 2000 installed on win 2000

I AM UNABLE TO SAVE ANY DATABASES

If I open an app which hides the database window the save button on the
toolbar and the save option on the Files menu show active.

HOWEVER as soon as I open the database window and click on a table then

The Save Button Greys and the save option on the file menu Greys out!

VERY BIG HELP!

Tools > Options No Locks, Open in shared mode

NB this occurred whilst develpoping an application front end connecting to
SQL Server.
The modifications I had made disappeared after closing and reopening the app
and it has since become unsaveable.
I then discovered the extent of this 'feature' !!!

I have
rebooted
reinstalled Access 97
to no avail

Apart from checking that the same was true of the 2000 installation I had
not had a 2000 app open for some days.

Jim Bunton






Jim Bunton

 

[[MVP] S.Clark]

There are lots of things to troubleshoot....
1. mdb with Linked tables or ADP with direct connection?
2. Do you have permissions to the tables?
3. Is the unsaved change a structure change?
4. Do you get the warning when opening to design view that the table changes
cannot be saved?