Date() & Time () Question

[Brigham Siton]

We have 2 machines running the same Access 97 database. One is a Windows XP
Pro and the other is Windows 2000. Both are updated to the lastest service
packs (XP sp1 & W2K sp 4).

However, on the XP machine, everytime it hits a sub procedure that has
either Date() or Time(), it halts saying library error.

On the W2K, it works fine. We also have some W98 machines and they all work
fine.

Is there any updating I need to do? What could be causing the problem?

Thank you very much.

 

[Gaël Schmitt]

It's probably a references problem.
Press "Alt" + "F11"
Look at if you have a reference marked like "MISSING"

If it's DAO unchek it, click Ok and "tools" "references" check it and click
ok

If it is the case, verify that it is quite necessary to your application (if
there it is not necessary uncheck it).


Verify which the DLL attached is quite present on the disc. And re-records
there by one:
regsvr32 "C:\Mpath\MyDLL.DLL "

Gael.

 

[Van T. Dinh]

Likely to be errors in the References Collection of your database.

See Douglas J. Steele's article:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[Brigham Siton]

I got this resolved.

Please see the link below.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;160870

Thank you very much for your help.

Brigham Siton

 

[Wayne Morgan]

It sounds like a Reference problem. Try the tips on this page.

http://users.bigpond.net.au/abrowne1/ser-38.html