MS Access 2003 Database not running under MS Access 2010
Posted on 2011-05-03
I rely on a custom Access Database that runs fine under Access 2003. I am trying to run it under MS Access 2010 but receive the following error message:
Microsoft Visual Basic for Applications: Compile Error: Cannot find project or library
The debugger shows an error highlighting the word "Date" in Me!SelectDate = Date 'Now()
Here is the full context of that error:
Private Sub Form_Load()
' Enter parameters in BeginningDate and EndingDate text boxes when
' form is loaded.
Me!BeginningDate = DateSerial(Format(Date, "yy"), Format(Date, "m") - 6, 1)
Me!EndingDate = Date
I had to copy some ocx files into the Windows\System32 directory and the Program Files (x86)\Office\Microsoft Office\Office14 directory to get the calendar and other custom forms to work, but they do not seem to be the issue here.
Any thoughts on where to begin fixing this?