#Errors#....what can be done?

[cavery]

Has anyone experienced or seen #Errors when dealing with records in Access? I have a network of users (105) on Access 97 where they constantly update, delete, run queries etc. Recently I've experienced errors from time to time, which doesnt allow me to compact or repair, so I have to copy and paste the data, then delete the record. Microsoft Help states the cause for #Errors are power outages, storms, etc. But I dont know if I totally agree with that. I started to compact my database (35,000 records) on a daily basis to try and fix this issue...

Any suggestions on what can I do to decrease these errors?

Thanks,
Clark

 

[jrbarnett]

#Error normally occurs when user A is trying to edit/read/delete a record that user B has locked for editing or deleted a record that user A is trying to access.

One way is to try doing a Requery on form data on a timer event to have it reload the data. I did this and it worked with 5 users, but haven't tried it with more.

John