What is the difference DBEngine vs Current DB?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone explain what the difference is between these two? and perhaps
when one approach is prefered over another?

Thanks for any insight!
 
Oft discussed question.

Run a search of microsoft.public.access at:
http://groups.google.com/advanced_group_search?hl=en

In essence, CurrentDb() is more up to date - essential if you have made any
structural changes.

dbEngine(0)(0) is more generic, has a longer lifetime, and quicker to
execute, though there are cases where it is not reliable. Particularly after
runnning a compact, wizard, or transaction, the default database could be
something else.
 
Back
Top