Access data keeps getting corrupted some how?

[paulmcdonnell]

Hi Guys,

I have a problems that I don't quite understand.

I have a database that sits on a server as an MDB file. We're having some server problems at the moment so I moved the database to a shared folder on my pc and everyone opens the mdb file from here.

However, after some time the database becomes corrupt. losing its indexes or now - "not a recognised database format". I can't seem to recover the database (but this is firefighting anyway) I'm confused. How can I track down what's causing this problem.

Its quite a serious one for me (i'm using access '97)

Cheers
Paul

 

[maxmangion]

so I moved the database to a shared folder on my pc and everyone opens the mdb file from here.

is everyone using the same version of Access ?

 

[adaytay]

Hi,

Am I right in thinking that the database is not split - ie all tables are in a "back end" db, while all the forms etc are in the "front end"?

If the db isn't split, I'd strongly recommend doing this.

HTH,

Ad

 

[paulmcdonnell]

Yes guys everyone has the same version of access and yes the database is not split. However this has worked fine for about 2 Years or so the problems has only arisen since i moved the database. but i have done some work on it too.

Does anyone know what causes these problems?

Cheers
paul

 

[Len Boorman]

Do you have Edited record locks set on add and update/Edit forms

Len