in access databse the function date() returns #name

[Guest]

i have created an access data base at access 2003 profisonal and used the
function date() it worked properly . but when i have coped my data base at
another computer at the same office , the funtion retuned (name#)

 

[Allen Browne]

Open the database on the problem computer.

Press Ctrl+G to open the Immediate window.
On the Tools menu, choose References.
Are any references marked MISSING?

More info on fixing reference problems:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[punjab_tom]

in Access; the Date function doesn't work sometimes.

it works all the time in SQL Server; but you've got to call it
GETDATE()