Hello everyone, I am encounterin

[crpjaviman]

Hello everyone,

I am encountering a small problem. I have multiple users that use a control that appends the same table. Here is the problem, when the first user appends 3 records, the records are added, when a second user appends 2 records from a different workstation, it overwrites the table and only adds the second users records.

The end solution needs to be that when both users appends, neither of thier records will be overwritten.

Can this be done per workstation? I don't like to make copies of the databases or make it exclusive, multiple users need the database at the same time, due to time contraints. Not to mention the update horror.
Is there some code that will help with this or is there a criteria statement in the query?

Any help will be appreciated.

Thanks,

 

[scriverb]

This is quite strange. How have you got your databases setup. Usually in a multiuser environment each workstation has a front-end database with the static tables, queries, forms, reports, modules while the dynamic tables are housed in a ever changing database which is stored on the server. The front-end is linked to the back-end through linked tables. Please confirm if this is how you have your environment setup.

If it is then the form that is supposedly creating the new appended records is possibly the culprit. Is it a bound form being bound to the back-end database through a RecordSource entry? What are the primary key indexes of the back-end table that you are trying to append? This one is important as if they are not appropriately setup then the second user may be just editing the record of the first users entries.

Are you using database replication?

We need a little more information to be able to understand the situation. If you provide this we can certainly help you solve your problem.

Bob Scriver