Access 2000 Vs Access 2003

[adam]

I try to run my query in SQL from access 2000 to 2003.
But the command Left([fieldname],2) could not be executed
and so the entire query. Please help anybody.

 

[Allen Browne]

This is either a problem with references:
http://allenbrowne.com/ser-38.html
or with the macro security nonsense in A2003.

If your references are okay, follow this article to disable Sandbox mode:
http://office.microsoft.com/assista...3&CTT=8&Origin=EC011081751033&Product=acc2003

 

[Michel Walsh]

Hi,


You probably have either a case of missing reference, either a case of
excessive security (not allow to run VBA code) with the new Office 2003
security thingy, or Jet sandbox mode (but I doubt that second case is the
problem). Assuming it is a case of a missing reference, from the VBE menu,
under Tools | References... you have a list of references. Among those that
are checked, one,or more, start their description with the word MISSING.
Uncheck those. Then, try to run the query another time.




Hoping it may help,
Vanderghast, Access MVP