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

[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.

 

[Jack Leach]

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)

 

[Tony Toews [MVP]]

Can't find project or library

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/