date format not recognised in 2003

  • Thread starter Thread starter Kim R.
  • Start date Start date
K

Kim R.

Is there a reason 2003 doesn't read formats in queries the same as in 2002?
Our office recently switched half of us over, and people with 2003 are
unable to open mde files for our database. Our workaround was to create two
versions. One from 2003 and one from 2002.

But the 2003 reports a query error on some of the reports.

The format itself is: Format([dateOfOccurrence],'yyyy').

I'm wondering if it's something simple that we're overlooking, and wondering
why we need to create two seperate mde's?

Was Access changed that much between versions?
 
Is there a reason 2003 doesn't read formats in queries the same as in 2002?
Our office recently switched half of us over, and people with 2003 are
unable to open mde files for our database. Our workaround was to create two
versions. One from 2003 and one from 2002.

But the 2003 reports a query error on some of the reports.

The format itself is: Format([dateOfOccurrence],'yyyy').

I'm wondering if it's something simple that we're overlooking, and wondering
why we need to create two seperate mde's?

Was Access changed that much between versions?
Click to expand...

Not at all. In fact 2002 and 2003 both use exactly the same database format!

My guess is that this is the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

You might need to recreate the mde files using the version of Access which the
users will be running, though.

John W. Vinson [MVP]
 
Back
Top