exebat <srdjan.vasiljevic (AT) gmail (DOT) com> wrote in
news:93c0d151-756d-43ce-bd22-8dfc0d80eb1d (AT) t2g2000yqe (DOT) googlegroups.com
:

Keep the references with the * and lose the rest:

OLE Automation provides no useful functionality, and is just a
default reference. If you are not convinced that it's not useless,
browse it in the object viewer, and you'll see there is simply no
justification for it in 99% of databases.

All the others except the latter can be used with late binding (and
should be, in my opinion).

You should consider what you're using the last one for -- if it's
for File Open dialogs, you can easily get rid of it and use the
built-in FileDialog, with no reference needed.

I don't believe any of this will resolve your problem (I think you
have corruption), but it will make for a better, more stable
database that will be prone to fewer problems on different PCs
(where installations can vary and references can break easily).

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

You can't have both references.

If you're using an MDB, you use the DAO 3.6 reference,

If you're using an ACCDB, you use the Access Data Object Enginer reference.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele/AccessIndex.html
Co-author: "Access 2010 Solutions", published by Wiley
(no private e-mails, please)


"Salad" <salad (AT) oilandvinegar (DOT) com> wrote

I tried Decompile an it doesnt work.

I also tried to import everything in the new database except the
startup form, and recreate that form and it did not help.

If I do compact and repair all works well.