a_southwould
New member
- Local time
- Yesterday, 18:18
- Joined
- May 12, 2004
- Messages
- 4
I am working on a database that is randomly giving me an error.
The error is the very generic "Microsoft Office Access has encountered a problem and needs to close. Sorry for your inconvenience". Responding with Debug or Don't Send (the error report) causes Access to crash.
After opening a new instance of the database, the error occurs when I open any form. I can open the forms in Design mode without a problem. The error does not occur once I compile the code. All forms open and run as they should.
The error occurs approximately half the time. It also occurs differently on different machines. The database may be working perfectly on my database, but copied onto someone else's machine will cause the error to occur. The database may be working perfectly and then give me the error after closing and reopening, even though no changes to data or objects have occurred.
The database is in development mode (original creation was around 2002) so it's not a conflict with multiple users. The database was once (out of my control) setup for replication, but that has since been removed. The database is around 50 MB.
My guess is that there is some corruption in a form or system table somewhere. I would really appreciate any thoughts on trying to locate the source of this error or pointers to any diagnostic tools that may help.
Oh, and I have Compact-and-Repair-ed (thousands of times). Thank you.
The error is the very generic "Microsoft Office Access has encountered a problem and needs to close. Sorry for your inconvenience". Responding with Debug or Don't Send (the error report) causes Access to crash.
After opening a new instance of the database, the error occurs when I open any form. I can open the forms in Design mode without a problem. The error does not occur once I compile the code. All forms open and run as they should.
The error occurs approximately half the time. It also occurs differently on different machines. The database may be working perfectly on my database, but copied onto someone else's machine will cause the error to occur. The database may be working perfectly and then give me the error after closing and reopening, even though no changes to data or objects have occurred.
The database is in development mode (original creation was around 2002) so it's not a conflict with multiple users. The database was once (out of my control) setup for replication, but that has since been removed. The database is around 50 MB.
My guess is that there is some corruption in a form or system table somewhere. I would really appreciate any thoughts on trying to locate the source of this error or pointers to any diagnostic tools that may help.
Oh, and I have Compact-and-Repair-ed (thousands of times). Thank you.
