How to change Dim statements from Access 2000 to 2007

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

Guest

Access code eg Dim MyDB as database works in Access 2000 but not in Access
2007 (running under Vista) Help!
 
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.
 
Didn't think there was a separate DAO library in 2007. Isn't it part of the
Access object library now?
 
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.
 
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
 
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
 
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.
 
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

trying to add data from a form to a table 8
Access VBA Statement (Access 2000 - Vb 6.0) "Dim MyDB As Database" 4
Object Name does not follow Microsoft Access object-naming rules 3
Message from Access 2007 on sub function 3
Strange error message: Database would be userdefined type!! 3
Run-time error 3061 - Too few parameters. Expected 1 5
Dim mydb as Database 4
How to list the names of forms and reports of an .mdb database by VBA 2

Back
Top