If I APPEND to a remote linked table, does it save time?

[Bill]

My application has a front end at each workstation. They
are all pointing to the same tables on a server box. I
want to minimize the time it takes to update, so I have
new records append to local tables and also append to a
linked table on the back end (which all workstations
access when they perform a local update).

Question: If I have many (up to 20) front ends appending
records to the backend, what conflicts or issues will I
face? I am using MS Access 2000 on win2000 machines.

 

[Kevin3NF]

so I have

new records append to local tables and also append to a
linked table on the back end (which all workstations
access when they perform a local update).

You have the same data in two tables?

When you say Append, do you mean normal adding of records via a form, one at
a time? Or do you mean running an append query to dump multiple records into
the back-end?

Either way, multiple inserts under a typical database setup should not be
any issue. If all 20 users are Appending thousands of records at the same
time, then yes, you may see some performance issues.

 

[JulianneBeeotch]

Could be Karma. Maybe you would have better luck if you would hold your wife when she cries rather than hiding in the back of the house. Just a thought.