First Try at Updating via code Help please

[yeatmanj]

Access queries are definately not the most efficient method of updating. They are slow because they have to keep retrieving information. SQL queries are much more efficient because they get the info once and store it locally until closed.

 

[RV]

Access queries are definately not the most efficient method of updating. They are slow because they have to keep retrieving information. SQL queries are much more efficient because they get the info once and store it locally until closed.

Not so, in fact, it's the other way 'round...
Static queries are considered to be faster than dynamic queries....

RV

 

[yeatmanj]

Here is a link that contradicts what you are saying. It may be worth your time to check it out. I enjoyed reading it. There is plenty of useful information, even if you don't agree with the dynamic vs static statements.

http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx

 

[RV]

Here is a link that contradicts what you are saying

I was referring to static queries versus dynamic queries in Access itself.
See for instance

http://www.access-programmers.co.uk/forums/showthread.php?t=84343

RV