Access 97 on windows 2000 server

J

Jim

Is there an issue with access 97 on windows 2000 server?...I have a text
field with a control source of Date()...The date shows up just fine on my
windows 2000 professional machine...but comes up as #Name? on the windows
2000 server machine....

Thanks
 
P

Paul Overway

The issue is most likely a reference. Open any module and check
Tools|References...most likely one is missing.
 
J

Jim

Hmm..It doesn't look like anything that is checked under references on my
machine is different then on the server...whats funny is that if I create a
new form in a different access databse on the server the Date() works..but in
the one I need it to work in it doesnt...Im using a mda file with this as
well...does this have anything to do with it?...Im totally lost
 
J

Jim

Wait....there is something missing...next to Microsoft SQL Parser Object
Library 1.0 there it says Missing:

Could this be casuing this problem and where can I get this?

Thanks
 
P

Paul Overway

Yes...that is what is causing the problem. First question is do you
actually need the SQL parsing object? Uncheck the reference and compile
your app...if it compiles, you don't need the reference. If it doesn't, I'd
still leave the reference unchecked and consider using Late Binding in those
places where you do use it (see help for CreateObject).
 
A

Albert D. Kallal

Make sure you installed the same updates to office on both machines.

For 97, you need:

sr1
sr2b
jet35sp3.exe

I have found installing the jet35sp3 has MANY times fixed the failure of
date(), left etc not working.
 
Top