LARGE QUERY MS ACCESS 2010

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.
SvgmassiveAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
jerryb30Commented:
Please post your append query.
0
 
SvgmassiveAuthor Commented:
i found the solution i had to increase the maxbuffer size in the registry.thanks
0
 
SvgmassiveAuthor Commented:
databaseMX i needed that thanks
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
:-)
0
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.

All Courses

From novice to tech pro — start learning today.