Microsoft Access and VB 6.0 Multiple connections

[singhkeshav]

Hello everyone...I am a beginner at programming database systems and i recently created one for my company using Visual Basic 6.0 and Microsoft Access 2003. I am facing some difficulty with the system and hope that someone will be able to aid me.

The problem occurs when several Clients input data. There was an instance where 3 employees were capturing data. Somehow data on one client's/employee's was more up to date than others. For instance if one client had 5 names stored in the database, the others only had 3. But in reality the extra 2 were not actually captured. When the client with 5 names shut down his system(VB 6.0) and restarted it, there were only 3 names in the list as well. ALL the Clients are connected to one datasource, and i used VB 6.0 to create the interface. I am facing a hard time trying to solve the issue.

[ergas]

Hi

Your question is very general.
A solution to your problem is somewhere in a way you have opened your recordset.

Scenario:
Two users opens a recordset from a database.
1st user make changes and saves to database.
2nd user make changes, he saves his changes and deletes changes from the 1st user.

There are some soulutinos in a way you open a recordset
- You can allow only one user to work on data at a time. He lock a database for other users.
- Allow all users to read a database and, when saving changes, to merge their changes to the changes of other users.

[jggtz]

You should give us more details
Are you using DAO, ADO ?
How are you connecting to database & tables?
How are you updating your data?
Post all relevant code about that

[hensa22]

how are you saving your data?