MS Access database mystery for newbie?

[Amir]

Dear All,
I have created small table in access,
then created ACCDE file for that database.
Then I shared that folder having accdb main file and accde file.
Then for clients I have opened this folder on there desktop and created shortcut of that accde file.

They started entering data and i left the place,
next day when i came back and opened shared folder ... i opened main accdb file which have about 150 records and the other accde file have 250 records.

Now i dnt know what happened and how it happened but its problem for me.
Anyone know the cause for this or know what i did wrong basically?

 

[BlueFeather]

From your description it looks like you have two separate databases, and expect entries your clients make in one to appear in the other - but that doesn't happen automatically.

To update one database with data from the other, open the non-client database and link to the appropriate table(s) in the client database. Now create and run whatever Append or Update queries are necessary to make records in the first match records in the second. When finished, remove the linked table(s).