G
Guest
Access code eg Dim MyDB as database works in Access 2000 but not in Access
2007 (running under Vista) Help!
2007 (running under Vista) Help!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
ruralguy via AccessMonster.com
You may need to specify the library: Dim MyDB As DAO.Database
D
Dirk Goldgar
In
If your issue is specifically with DAO objects, make sure you have a
reference set to the DAO object library.
MichaelB said:Access code eg Dim MyDB as database works in Access 2000 but not in
Access 2007 (running under Vista) Help!
If your issue is specifically with DAO objects, make sure you have a
reference set to the DAO object library.
G
George Nicholson
Didn't think there was a separate DAO library in 2007. Isn't it part of the
Access object library now?
Access object library now?
D
Dirk Goldgar
In
You could be right -- I don't know, not having a computer with A2007
handy at the moment.
George Nicholson said:Didn't think there was a separate DAO library in 2007. Isn't it part
of the Access object library now?
You could be right -- I don't know, not having a computer with A2007
handy at the moment.
A
AnandaSim
In
You could be right -- I don't know, not having a computer with A2007
handy at the moment.
Uh, guys, the world hasn't turned upside down. There's no way
Microsoft can merge a programmatic data access library into Access and
not change too many things. DAO is still an independent library as is
ADO in Office 2007 -
The formal title for Access 2007 is:
Microsoft Access 12.0 Object Library - MSACC.OLB
The formal title for DAO is:
Microsoft Office 12.0 Access database engine Object Library -
ACEDAO.DLL
hth
Ananda
G
Guest
Many thanks everybody. I found dao.2535.tlb on my old computer and copied it
into the System32 folder on my new machine. My macros now seem to be OK, they
compile anyway!. very many thanks to all who took the trouble to write. Best
wishes Michael
into the System32 folder on my new machine. My macros now seem to be OK, they
compile anyway!. very many thanks to all who took the trouble to write. Best
wishes Michael
G
Guest
The problem was that my macros were written for Access 2000 and 2007 does not
include dao2535.tlb I had to copy from my last computer.
include dao2535.tlb I had to copy from my last computer.
D
Douglas J. Steele
Access 2007 doesn't include dao2535ltlb because it doesn't use it (nor did
Access 2000, for that matter).
That library was intended for backwards compatibility in Access 97 for
applications written in earlier versions of Access.
Access 2000, for that matter).
That library was intended for backwards compatibility in Access 97 for
applications written in earlier versions of Access.