Improve company productivity with a Business Account.Sign Up

x
?
Solved

LARGE QUERY MS ACCESS 2010

Posted on 2013-11-12
5
Medium Priority
?
607 Views
Last Modified: 2013-11-13
I have a query that has over 15000 records that needs to be inserted in to another table i am using an append query to do this everything worked fine in ms access 2003,query hangs in 2010 any suggestions.
0
Comment
Question by:Svgmassive
  • 2
  • 2
5 Comments
 
LVL 26

Expert Comment

by:jerryb30
ID: 39643475
Please post your append query.
0
 

Author Comment

by:Svgmassive
ID: 39643576
i found the solution i had to increase the maxbuffer size in the registry.thanks
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft Access MVP) earned 2000 total points
ID: 39643594
No need to mess with the Registry.

You can easily do this in code - on a 'per session' basis.

'set max locks
DAO.DBEngine.SetOption dbMaxBufferSize, 1024' or higher if necessary

'execute the append query
CurrentDb .Execute "YourAppendQueryNameHere", dbFailOnError

Not even sure why you would need to do this with only 15K records ...
0
 

Author Comment

by:Svgmassive
ID: 39646634
databaseMX i needed that thanks
0
 
LVL 75
ID: 39646645
:-)
0

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question