Jet Database Error

[jasn_78]

I am receiving the following message when a customer tries to query a record any suggestion would be grateful

'the microsoft jet database stopped the procedure because you and another user are attempting to change the same data at the same time.

Jason

 

[Fizzio]

What do you mean by 'query a record'.
I'm assuming that your application is in a multi-user environment. If so, what locking restrictions do you have in place?

 

[jasn_78]

This databse is just one that the client made themseleves hell it is only 1 table and what happnes is when some1 runs a filter on the table it comes up with this error the prob is all other machines have been switched off at this time so it is not like any1 else is using the databse.

 

[Fizzio]

2 things
1) Never a good idea to let users loose on the tables themselves - better to use query by form
2) the ldb file may be corrupt (especially if someone did not close the Db properly). Close the Db and if the ldb file still exists, delete it then re-open the Db

HTH