Access 2000 Vs Access 2003

A

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.
 
M

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
 
Top