year(date)

[Guest]

I have just converted an Access V2.0 database to V2000 format inV2003.

When I try ?Year(Date) in the it in the immediate window in V2.0 I get 2004.
In 2003 I get a Run-time error '13': and Type mismatch message with options
to End, Debug or Help.

Can anyone tell me why?

I suspect this is going to be the first if many

 

[Allen Browne]

Check out the references (Tools | References, from a code window).
More info on references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

Disable sandbox mode (Tools | Macro | Security | Low).
More info on sandbox mode:
http://office.microsoft.com/assista...3&CTT=8&Origin=EC011081751033&Product=acc2003

For a list of gotchas when converting from Access 2, see:
http://members.iinet.net.au/~allenbrowne/gotcha27.html
and a list of issues converting to A2003, see:
http://members.iinet.net.au/~allenbrowne/ser-48.html