[AccessD] Date() not working - MDAC issue or not?

I would rule out a missing reference issue first, but if that's not the case then it could be an MDAC issue, I've had that in the past, but a few years ago, I believe it was MDAC 2.5 or 2.6 that was problematic.

-Chris Mackin

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Kath Pelletti
Sent: Thursday, November 04, 2004 3:23 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Date() not working - MDAC issue or not?


Hoping someone can shed some light here....

A client using Windows 2000 Pro and Access 2000 has been using an mdb written in Access 2000 for several years. But this week when I installed an upgrade (same platform), the Date() functions throw errors, as do the Format() functions.

They have a critical error at the moment caused by Date() notworking which I need to fix today. I know I could modify these functions to use, eg. Now(), but is this a MDAC problem? Mine is MDAC 2.7 on Windows XP SP1. 

If I asked my client to download MDAC 2.8 (which I see is the latest) - is this going to solve the problem?

I do not understand how this upgrade could possible have afftected the use of these functions??

Thanks

Kath
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com