Solved

LARGE QUERY MS ACCESS 2010

Posted on 2013-11-12
5
520 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 - Access MVP) earned 500 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
IT Desktop Support 11 65
What's wrong with CopyFromRecordset 6 33
Attachment field in SQL 3 26
Batch Export Reports (with multiple parameters) As PDF 2 21
The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

785 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