Question: Access 97 I'm receiving #Name? error when using the Date() and other common functions when I install my db on another machine. It works OK on my machine.
You more than likely have a "Library Reference" problem on the machine giving you the error. On the problem machine open a module in design view, click the Tools button in Access main tool bar, then choose References. In the References list you will see a checked reference that has "Missing" message attached to it. This is the one causing the error. Uncheck the culprit and the problem should be cleared up.
Most of the time the problem originates from the machine where the Access app is written on. I have found this is commonly caused by someone using non-standard activeX controls and other components that are not basic to Access. If you play with an activeX component then even if you delete it from your application the library reference will still be loaded in the current app unless you uncheck the reference. Thus when you install the app on another machine the result will be a library reference error. Unless you are doing something exotic there normally should be only three references checked. For Access 97 these are:
Visual Basic For Applications Microsoft Access 8.0 Object Library Microsoft DAO 3.51 Object Library (version can vary)
If you are doing some things with Excel through Access you will also have an Excel Library check also. If you have others checked they can very well cause a problem if the other machines do not have the libraries registered on them. I hope I have explained this clearly enough. I too have encountered this problem in the past.