I have been having some problems with Missing Object Libraries in my database, and having searched this forum have realised that the solution appears to be to convert references for Excel, Word and Outlook in vba to Late Binding
I believe I have done this throughout my project but am still getting the same Missing Object Libraries error.
The database was created in Access 2000 format, I am using Office 10, other users have Office 2007 and 2003
I have some lines of code which use OutputTo with Excel, example below
DoCmd.OutputTo acOutputQuery, strQueryName, acFormatXLSX, strFileNameASB5North, False
and am wondering if these may be part of the problem
My question is
Is there a way to check I have captured all the early/late binding required, ie a list of functions etc that may cause the Missing Library Objects problem.
If so could someone point me in the right direction
Thanks
Rnutts
I believe I have done this throughout my project but am still getting the same Missing Object Libraries error.
The database was created in Access 2000 format, I am using Office 10, other users have Office 2007 and 2003
I have some lines of code which use OutputTo with Excel, example below
DoCmd.OutputTo acOutputQuery, strQueryName, acFormatXLSX, strFileNameASB5North, False
and am wondering if these may be part of the problem
My question is
Is there a way to check I have captured all the early/late binding required, ie a list of functions etc that may cause the Missing Library Objects problem.
If so could someone point me in the right direction
Thanks
Rnutts
