Question Lost data

[ibbledibble]

I designed a database in Access 2007 which is used by separate offices across our organisation. It has a main table, with a related sub-table in a one-to-many relationship.

Recently, a user in another office decided to split the database because they were having difficulties using it simultaneously with other users. I told them to go ahead but to make a backup first, in case of any problems.

It now appears that they have lost a considerable amount of data from the sub-table. The main table is fine, but when the related sub-table is opened a lot of data has simply vanished (we use forms to access the data for day-to-day use and to enter new records). Bizarrely the same data has also disappeared from the Backup.

There have been other strange occurences with this DB, such as codes going missing from a field, and a duplicate field appearing on a form. The user swears they haven't tried to modify the DB in any way, shape or form :banghead:

I'm lost for a solution. Many thanks in advance to anyone who can help.

 

[Galaxiom]

It wasn't the splitting that caused the problem but having an unsplit database with multiple users accessing it. It was a disaster waiting to happen.

The missing data from the backup is not bizarre. The damage had already been done before the backup.

 

[ibbledibble]

ok, there were only two users accessing this particular database. We have the same one in my office and have never had any of these problems.

So just by having two users accessing the DB, it can cause substantial lost data - we're talking about 500 records.

 

[ibbledibble]

Any other suggestions please?

 

[ibbledibble]

And another question would be if it is possible to see a history of modifications to a database?