Question Reserved Error -1524 and Missing ref dao2535.tlb

[cbridges]

A client called and said they had upgraded from Office 2007 to 2010 and to Windows 7. I only had a fews issues with forms at first. I was getting a message "Missing or broken VBE reference to the file 'dao2535.tlb" and a couple reports are giving me the Reserved error -1524 message. Another blog said to remove the reference to the dao2535, which I did. Now, when attempting to find the corruption in the one table, using an Append Query, the Conversion Error file stops with the following record. I'm not sure where to go from here. I can't find this reference in tools, now.
Any suggestions would be greatly appreciated.

Conversion Errors1Object TypeObject NameError DescriptionDatabase
Missing or broken VBE reference to the file 'dao2535.tlb'.

 

[GinaWhipp]

What References do you have checked? See...

http://www.access-diva.com/d5.html

 

[the_net_2.0]

have you looked up dao2535 on the web?

There is a lot of changes from pre-win 7 to win 7. The most significant one is 32 bit machines to 64 bit machines. Libraries and DLL's DO change locations when you get Windows 7, or a 64 bit machine in Vista.

I'm guessing that's the problem. I'm not sure if dao2535 is the name of the DAO dll. It doesn't look like it, so I'd look it up if I were you.

If you need it, I'm betting it's changed locations in Win 7.

On a side note, I have a 64 bit Vista machine and I have access to 2 DAO libraries. They are:

1) Microsoft Shared\DAO\dao360.dll
2) Microsoft Shared\office\ACEDAO.DLL

That's for MS Access 2007

 

[cbridges]

The references I have checked are:
Visual Basic for Applications
Microsoft Access 14.0 Object Library
Microsoft DAO 3.6 Object Library
OLE Automation
Microsoft Visual Basic for Applications Extensib3ility 5.

 

[GinaWhipp]

You didn't read the bottom of the page. Remove the check mark next to...

Microsoft Visual Basic for Applications Extensibility 5

...then Recompile and open the database as normal.

 

[dbaker27]

Better yet!!!!! Create a new database in Access 2007 and import from the old database. You will get the error message yet, but no worries, you will be presented with the list of tables to import, and it works!