I have a database that has several users linking and appending data
throughout the day. obviously they can't run the same link or append at the
same time but even if one user is running Append #1 and another user just
happens to have the database open it causes severe performance ...

Ok, here is my dilemma.
I currently have a SQL statement that queried an EXCEL sheet which had
pricing and product descriptions from the head office.
Now i wish to make a query that aides the sales staff by searching the

I have an Access table containing the fields "Qty In" and "Qty Out". Only
"Qty In" has data in it, representing the beginning balance. I have written
a query to substract the sum of "Qty Out" from the sum of "Qty In" to return
a current balance for each product. My problem is, ...

I have a SQL database with only about 500 records.  It originates from an
Excel file that I use to append the records.  I created an append query in
Access  to only appending one field (the KEY).
When I ran the query, (with 550 records - forty some new records) - it