Reference Library Error

[Mike D]

When I run a 2003 Access Db in 2007, I get the error message: Undefined
function 'Left' in expression.
How can I find which library reference contains these expressions?

 

[Maarkr]

don't have 2007 at work here, but is there a 'Visual Basic for Applications'
reference?

 

[Mike D]

I am working with a 2003 Access DB in Access 2007, I checked the reference
libraries for VB and all the correct libraries are checked and in place. I
was thinking maybe I had to check a library for 2003 to get the commands
active in 2007

 

[BruceM]

Perhaps there is something here that will be of use:
http://allenbrowne.com/ser-38.html

 

[Mike D]

Thank you for the help, I found the issue. There was a password on the VB
application in the 2003 DB. The security in 2007 blocked access to VB without
the password. I imported all into a blank DB and it works. When I imported,
it did not import the VB Password requirement.