Access keeps crashing

[Valerie]

I have an Access 2000 database with upto 6 users. (split into Front end and Back end)

Whenever a user logs into the database he sees a message like "unrecognised database format" and the other users' data is not saved.

This problem has started quite recently and until then there were no problems at all.

Eventually the effect of this is that the tables lose their primary keys and the relationships are deleted.

Any suggestions would be gratefully accepted.

Valerie

 

[Mile-O]

PRB238401

 

[Valerie]

Thanks for your reply. I have checked out the article and it implies that maybe I have not got the correct references. I have checked my references and see that I have the following references:
1) Visual Basic for Applications
2) Microsoft Access 9.0 Object Library
3) OLE Automation
4) Microsoft Calendar Control 10.0
5) Microsoft DAO 3.6 Object Library
6) Microsoft Visual Basic for Applications Extensibiliy 5.3

The exact message which is being displayed is

"You or another user may have unexpectedly quit MS Access while the MS Access database was open. Do you want access to attempt to repair."

Do you know if the same solution will resolve this message for me.

 

[Mile-O]

Have you tried:

• compacting and repairing;
• import every object into a fresh database;

 

[Valerie]

I have compacted and repaired on numerous occasions!!

I will try creating a new file and then importing all the tables.

Thanks for the suggestion

 

[Valerie]

I have now created a new data file and imported all the tables and reset all the relationships.

The system has just crashed again! (after about 1 hour of use) Have you any other suggestions? Please???

Valerie