Greetings:
I am having a problem with a recurrent error message in our Access application of "Object not set". We are running MS Office Professional 2003, best I can determine the only updates I see in the server program population is compatability pack update for Office 2007.
This is a program we purchased from a software vendor several years ago and they have since gone out of business. The front end is encrypted, I can make no changes to any of the tables, queries, reports or forms. But I have managed to create new ones and can view the structure of everything, but make no changes.
When the "Object not set" error occurs, I have tried packing and reindexing which previously fixed the problem. Now for whatever reason this will not work. I end up having to restore our backup from the night before that results in lost data.
Any ideas what may be causing this and any recommendations as to how to keep it from happening? It happens about once a month, which is still too often.
Thanks in advance for any help.