Will not save
I have a very large Access 2000 database used by my mechanic. It works well except I am no longer able to make changes. Any simple change to a form tests correctly, the form appears to save, but the changes are gone when MS Access is next restarted. Changes to a module appear to save when I click the "diskette" save icon, but when I come to close the code form it displays the message, "The database Jet database engine could not find the object ''. Make sure the object exists and that you spell its name correctly."
Note the empty single quotes after the word "object".
After clicking OK it displays -
"You tried to commit or rollback a transaction without first beginning a transaction."
This is displayed after editing code - I have not opened the form for display.
It finally comes up with a messae "Do you want to save the changes to the design of the form 'sfPurchaseLines'. After recycling through the messages I have to click no, and loose everything.
The bahaviour is the same on both PCs. Both have 500 meg ram and are over 2000 mhz.
My mechanic purchased new Win XP and Office 2000 because his hardware supplier told him that was where the problem was.
I sure would appreciate help on this one.