Access 97 on windows 2000 server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
The issue is most likely a reference. Open any module and check
Tools|References...most likely one is missing.
 
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
 
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
 
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).
 
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.
 
Back
Top