[AccessD] TableDefs vs. QueryDefs

jwcolby jwcolby at colbyconsulting.com
Wed Oct 24 08:52:30 CDT 2012


A succinct and cogent explanation and solution to the problem.

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 10/24/2012 9:05 AM, Jim Dettman wrote:
>
> <<So it's best to get a Db object initialized and use that throughout your
> code.>>
>
>   You have to be careful how you handle that.  I wrote an article on what I
> think is the best overall solution for both performance and avoiding the
> pitfalls:
>
> CurrentDB() vs. dbEngine.Workspaces(0).Databases(0) and an alternative
> http://rdsrc.us/OjCqDe
>
> Jim.



More information about the AccessD mailing list