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

I have found that there is a difference in the order of the DAO / ADO references....

The reference to DAO in the latest release is above the ADO reference.

Could this throw the error with Date()?

Kath

  ----- Original Message ----- 
  From: Kath Pelletti 
  To: Access Developers discussion and problem solving 
  Sent: Friday, November 05, 2004 9:36 AM
  Subject: Re: [AccessD] Date() not working - MDAC issue or not?


  Chris - I checked the references on site and found none missing...
    ----- Original Message ----- 
    From: Mackin, Christopher 
    To: Access Developers discussion and problem solving 
    Sent: Friday, November 05, 2004 9:29 AM
    Subject: RE: [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
    -- 
    _______________________________________________
    AccessD mailing list
    AccessD at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/accessd
    Website: http://www.databaseadvisors.com
  -- 
  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com