Question VBA code and References dissaper

[timf79]

Howdy,
I have a Database that all of sudden lost all VBA code and the references to the libraries.

The stranger thing is that there was never an error message.

I had the same thing happen to me in other databses as well?

Any ideas?

 

[boblarson]

Possible corruption. Are these databases multi-user and are they split to a backend/frontend?

 

[timf79]

It is a single file, which is access by only one user.

My theory is that it has something to do with the fact that the database is saved on a network drive.
Though the whole database is only 6MB small.

The data as well as any querries, forms, etc. is 100% fine.

 

[boblarson]

It is a single file, which is access by only one user.

My theory is that it has something to do with the fact that the database is saved on a network drive.

Yes, if a user is connected to the database file (unsplit) and even a brief network disconnection occurs, then it will likely corrupt. Even for a single user, the file should be split and the frontend be on the user's computer.

The data as well as any querries, forms, etc. is 100% fine.

As far as you know, but it may not be for long as the symptoms you describe would tend to indicate corruption creeping in.