Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Type library version problem

    I'm developing a database in A97 on my PC, and creating a run-time version
    via ODE for distribution. When I install the run-time on my test PC which
    does not have A97 installed, the app fails with a "Function not
    responding.." error message. This relates to the Date() function in a query.
    MSDN Q194374 tells me how to fix the problem, but the fix does not work. I
    create & remove a reference in the developer version, re-compile &
    re-install, but the app still fails with the same error message.

    Anybody out there got any other ideas on how to fix this one ?

    Thanks

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Type library version problem

    Try the references wizard from The Access Web:
    http://www.mvps.org/access/modules/mdl0022.htm

  3. #3
    DAW
    Guest

    Re: Type library version problem

    Hi Nick,

    I had a similar problem with one of our Access 97 apps. The application would not recognise the expression Format(Date + 1,"dd-mmm-yyyy") in a query. It worked from the debug window and from code but just wouldn't work in any queries.

    I wrote my own function TomorrowsDate() that returned the appropriate date in the required format. This worked OK from the queries.

    In the end I had to start a new blank database and import all the objects one by one. My original expression then worked OK in the queries. Strange. Never worked out why.

    Dave.

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Type library version problem

    Thanks, but I've already been down that route. The wizard shows all references are fine.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Type library version problem

    Did you try Nick's tip.
    Make a new mdb. Import all the stuff from the old MDB and try again.
    Sometimes this is the magic solution to a lot of strange problems.

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Type library version problem

    Bart

    I did indeed try out DAW's tip. I imported all the objects into a new database, re-compiled & re-installed. On the test PC it came up with run-time error 3071 "The expression is typed incorrectly, or it is too complex to be evaluated". The problem is still with the original query. Here's the SQL for it :

    SELECT DISTINCTROW tblUpdate.Updated, tblUpdate.Day
    FROM tblUpdate
    WHERE (((tblUpdate.Day)=format(Now(),"dd-mmm-yyyy")));

    The 'funny' thing is the app works perfectly on a PC where Access 97 has already been installed. It's these little things that really make your day, don't they ? (Not)

    Nick

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Type library version problem

    OK,
    There is the problem:
    Try this one:

    SELECT DISTINCTROW tblUpdate.Updated, tblUpdate.Day
    FROM tblUpdate
    WHERE (((format(tblUpdate.Day,"mm-dd-yyyy")));

    I assume tblUpdate.Day is a date field.
    Access expects dates to be mm-dd-yyyy.

    Posters of the lounge: if you get an error message POST THE CODE!!!!!!
    With the code it is easier to give help!

  8. #8
    DAW
    Guest

    Re: Type library version problem

    ........ = Date()


    Dave.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •