"Can't find project or library" on user defined variables. 2003 -

  • Thread starter Thread starter rc51wv
  • Start date Start date
R

rc51wv

I created this DB in Access 2003 and I tried opening it with Access 2007. I'm
getting:

Complie Error:

Can't find project or library

When attempting to use anything in the DB. At first I thought it was
something to do with ADO as the first variable had to do with an ADO
connection. I opened another form and tried to do a search and now it's
giving me this error on a string variable that's an SQL statement. I tried it
a third time on another function setup in the database and it gave me the
error on the Right function.
 
The sounds very much like a reference issue.

Have you verfied that all of the references in the 2007 version match those
that are in the 2003 version?

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)
 
rc51wv said:
Can't find project or library
Click to expand...

Reference error. Run the following code and let us know the results.

Sub ViewReferenceDetails()

Dim ref As Reference

For Each ref In Access.References
Debug.Print ref.Name & " - " & ref.Major & "." & ref.Minor & "
- " & ref.FullPath
Next ref

End Sub


Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
Back
Top