Multiple users append same table.....

[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,
crpjaviman

 

[CasperTFG]

How are you connecting to the DB. If your using a data control there is a setting that will do batch locks.

If your using ADO, I always keep my connections closed, then when i need to make a change to the DB, i.e. once I'm all ready with my data, I open the connection right the info, and close the connection. THis all happens in a matter of milliseconds, and the good news is, even if 100 people access the DB, the lock time on the DB is minimal. Craig, mailto:sander@cogeco.ca

Remember not to name the Lambs...
It only makes the chops harder to swallow

 

[mmilan]

Darn Craig...

I'm trying to get around a multiuser ADO at work, and I was hoping that you might have something more, well, inciteful to say.

As it is, I guess I'll be pulling another chunk of hair out...

mmilan

 

[DonMc67]

what DB are you talking about... please don't say Access

 

[crpjaviman]

The database is Access. I looked for a setting but was unable to find it. The only thing I found was the records lock, but does not allow for multiple user to access the form at one time.

Right now I am trying a "create table" in SQL and "insert into" from a query statement, but I haven't worked out the finer points yet.

Any suggestions?

crpjaviman

 

[DonMc67]

Access doesn't work well with multiple users, I don't know the truth of this but the way it was explained to me is that when you open a table you are actually working with a copy on your local machine. When you update that table you are copying it back to the server, that is why it appears you are overwriting...