Link to home
Start Free TrialLog in
Avatar of Bill Feder
Bill Feder

asked on

Append Query Access 2010

We have a very simple append query that updates our inventory table with
the most current information.  Every year when we do a physical count I append
the records. The inventory table has about 29000 record and I need to add another
another 3900 record with the append query. When I start the query access seems
to start OK but will soon locks up and the only way out is to shut down and restart.

I have no now idea why this happens. You name it and I have done it: Importing, exporting,
moving locations, compacting, renaming etc. I have been doing this for sixteen years
and never had a problem until yesterday. I have no idea and hope there some one else
might be able to help.
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

what is the source of the records you want to append?
Avatar of Bill Feder
Bill Feder

ASKER

I have attached the file, Inventory_March_31_2013 is the source .
2017 Inventory has the records and 2017 query. I have attached
the Inventory-2017.accdb file that contains them.

Thanks
Inventory-2017.accdb
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you very much. It worked the first time without any problems.
Is writing out query's what i should be doing.