How to change Dim statements from Access 2000 to 2007

M

MichaelB

Access code eg Dim MyDB as database works in Access 2000 but not in Access
2007 (running under Vista) Help!
 
R

ruralguy via AccessMonster.com

You may need to specify the library: Dim MyDB As DAO.Database
 
D

Dirk Goldgar

In
MichaelB said:
Access code eg Dim MyDB as database works in Access 2000 but not in
Access 2007 (running under Vista) Help!
Click to expand...

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?
 
D

Dirk Goldgar

In
George Nicholson said:
Didn't think there was a separate DAO library in 2007. Isn't it part
of the Access object library now?
Click to expand...

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.
Click to expand...

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
 
M

MichaelB

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
 
M

MichaelB

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.
 
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.
 

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
VBA Export to PDF 0
Page numbering with Merged Document and IF statements 1
Dynamic Naming of Form Button 3
trying to add data from a form to a table 8
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Access 2002 change report header text 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0

Top