Access 2007 crashes when using subform in datasheet view

[ccampbell107]

Two people are using Access 2007 (database is not split) and both are working
in datasheet view but not on the same set of data. Every third or fourth
time they open a subform, the program kicks one of them out and the data is
lost. Would splitting the database solve the problem? Thank you

 

[M Skabialka]

Splitting databases fixes a whole mess of issues - not the least of which is
less chance of losing data. It's really easy - there's a wizard to help you
through it. If your front end on someone's desktop PC crashes you aren't
going to corrupt the back end with the data anywhere near as easily. And
you can open the same form, though not the same record because of record
locking. Also you can continue to modify your copy of the front end forms
and reports without affecting other people, and give them a final copy once
you have it production ready. Plus, it seems to work faster from my
experience if the FE is on their PC.
Mich