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

  • Thread starter Thread starter Bill
  • Start date Start date
B

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.
 
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).
Click to expand...

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.
 
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.
 
Last edited:
Back
Top