VBA References

J

JimP

In MS-Access 2003, I have typically set references to (among others),
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.5 Library

MS-Access 2007 installs with a reference set to,
Microsoft Office 12.0 Access database engine Objects

Does "Microsoft Office 12.0 Access database engine Objects" duplicate in
any way the other references? Will I still need to set the DAO and ActiveX
references?
 
A

Allen Browne

You should *not* use DAO360.DLL in an ACCDB.

In Access 2007, open the Immediate Window (Ctrl+G) and enter:
? References("DAO").FullPath
In an ACCDB, this will be ACEDAO.DLL
In an MDB, this will be DAO360.DLL
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
Problems starting Word from Excel VBA 3
Access 2007 - whatever happened to ADO and DAO ? 4
ADO -DAO problem 1
Reference Issues 3
A2007 Libraries needed for ADO Connection 1
OLE Server and ActiveX Error 0
Which reference libraries should i check 2

Top