data disappearing, multi user database

[jules68]

Hi All,
I have a problem with a multi user database (access 2007) and the data disappearing from tables.

This is happening when there has been 2 users in the database. One person is updating a tablel through a form, (data has been then checked it is there in the tables). However, the next day the data is not there. Somehow the data is not saving when both people close the database.

To me this is strange, the record is immediately saving when database is in use but i'm not sure how the database would dump it overnight as there is definitely no code in the db that would do this.

The property sheet onthe form definately allows for additions and edits.

Anyone have any ideas.

Thanks

 

[Catalina]

Have you checked in the actual tables if the date is there?

Catalina

 

[jules68]

yes, i've checked the tables and any data that was entered whilst2 or more people have been in the database appears to save when checked after entered, but then it is not there when the database is closed and reopened. (after all users have closed the database).
thanks

 

[Beetle]

Is your database split, with the back end on the network and each user having their own copy of the front end?

 

[jules68]

No its not split, multiple users are opening it from the same file (location).

 

[Catalina]

Not splitting it is a recipe for disaster.

May be this will help you:

http://www.techrepublic.com/blog/10things/10-reasons-to-split-an-access-database/1119

There are a lot of posts here too about this subject.

Catalina