in access databse the function date() returns #name

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

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#)
 
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]...
 
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()
 
Back
Top