Problems switching from 2003 to 2007

[benkingery]

I have a bunch of code that was written in 2003. I have since "upgraded" office computers to Access 2007. Now I am having issues running the same code that has worked without problems for ages.

An example: Date() doesn't work in VBA code or update queries. I'm given the message "Run-time error '3085': Undefined function "date" in expression.


Another example: In a query I have Format([Transaction_Date_006], "yyyymmdd"). This has worked flawlessly to give me the date as I need it for the column in the form of 20101015. Not so now.

Any idea? Am I missing an object library reference or something? The problems seem to have just cropped up recently.

Thanks,

Ben

 

[boblarson]

Have you "upgraded" the file to an ACCDB format or are you just using the old mdb file?

And, have you set the location of the database to be a trusted location?

 

[benkingery]

I have not upgraded to the ACCDB format. I am using Access as a front end. Do I need to do this? I'm not exactly sure how to do that. Until now I haven't had this problem. I did set the file locations that I'm running the MDB from to be a trusted location. Still no effect there.

 

[benkingery]

Strange enough, it looks like this was a Microsoft DAO object library reference problem. I unchecked the object library reference and now the problems have gone away......Not sure I understand why.