Versions of Access

[JasGun]

In my department at work we are using Access 97.
When we create a database for a different department some of the functions don't work on the machine e.g. Right(), Left(), date(), Now().

Does anyone know why the work on our machines, but, not theres? If you know how to resolve these I would be very grateful.

Thanks

Jason

 

[tlbroadbent]

Check these threads where the issue has been discussed already - thread181-23042 and thread181-88376. Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I shall try to correct errors when shown to be errors, and I shall adopt new views so fast as they shall appear to be true views." - Abraham Lincoln