running Access97 on network - DATE problem

[Dave Berg]

I am running Access 97 on a 4 machine network. 2 running
Windows 97, and 2 running Windows 2000 professional. I
recently replaced one of the Windows 97 machines with a
new one ( XP home)... I have no problem with the network
or connecting between the machines except for the fact
that any reference made in the Access program to DATE
causes a halt on the XP machine with the error "Can't find
project or library". All other aspects work fine but
without a system date reference the program is obviously
useless on this new machine. I checked Regional settings
etc. and can find no incompatibility. Also, if i write a
quick test program on the new machine and reference
DATE... it finds it no problem. Any thoughts?
thanks in advance.
Dave

 

[Kristyn Wagoner [MSFT]]

This appears to be a very common problem with references on the new machine.
Since DATE is a VBA function, take a look at this article to check if you
have some missing references.

160870 ACC: VBA Functions Break in Database with Missing References
http://support.microsoft.com/?id=160870

Hope that helps!

--
Kristyn Wagoner
Microsoft PSS

Please do not reply directly to this alias. This alias is for newsgroup
purposes only.

This posting is provided "AS IS" with no warranties, and confers no rights.