Problem running database on another machine.

[Jack Gillis]

Can anyone help me solve this problem? It is a prevents me from doing
what I need to do. That is, run a database created on one machine on
another machine.

I have Office 97 installed on two machines both running under Windows XP
Home. Each Office 97 installation is identical as far as I can tell and
both are current as far as updates go.

I also have a Database (mdb file) that works perfectly on the first
machine, the one on which it was created, but on the second it does not.
One text box in the header of a report has as its control source
=Date(). On the first machine, the date appears as advertised. On the
second machine, #Name? appears instead of the date. This also happens
with the same sort of text box in the header of a form. (The same
condition exists if I make the mdb an mde.)

When I try to edit the Control Source of the box on the second machine,
I get a message like this:

The function you entered can't be used in this expression.

*You may have used a DoEvents, LBound, UBpund, Spc, or Tab function
in an expression.

*You may have used an SQL aggregate function, such as Count, in a
design grid or in a calculated control or field.

Neither of the two conditions apply as far as I can tell.

I really need and will appreciate help on this.

Thank you.

 

[Sandy Shin]

try datevalue(Now()) this has fixed this error for me
sometimes. If you start a new database in the second
maching will a textbox accept the =Date() value? if so
you might try starting a new database in the second
machine, importing everything from the old database,
compliling all code and see if that works

 

[Bruce M. Thompson]

You may be a victim of the "missing references" problem. For an excellent source
of information on this problem and fixes ranging from "quick" to "advanced", see
the following page at Doug Steele's web site:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html