error message about broken reference

[keighley]

I'm getting an error message which says 'your microsoft access database or project contains a missing or broken reference to file dao2535.tlb version 3.5, to ensure your database works properly, you must fix this reference.' If I click OK enough times i am still able to use the database but does anyone know how I can fix this?

[Irishlad1967]

From Microsoft Answers: http://answers.microsoft.com/en-us/o...4-0b1caacf61cb
Most errors in microsoft products are documented online if you type the error message into your search engine.

It appears your old database file still has a referenced in it that is looking for dao235.tlb on your machine. Unfortunately, this is an old dao file that doesn’t ship with the newer versions of Office and /or newer operating systems. In most cases, you should be able to uncheck the reference by doing the following:

+>Make a copy / backup of your database file.
+>Open your database in Access 2010.
+>Click Ok on the error message (you may have to do this several times).
+>Press Alt + F11 on your keyboard to bring up the VBA window.
+>Click on Tools and then select references. You may receive the error message again when doing this. If you do, once again just click Ok.
+>You will see a few references checked at the top of the reference dialog. I would assume one of these references is for the dao235.tlb reference and it most likely is preceded with the word Missing. Uncheck this reference.
+>I would then recommend trying to check the dao 3.6 reference by scrolling down in the list and checking “Microsoft DAO 3.6 Object Library”.
+>Now try closing and reopening your database.