Query parameters

[moben]

The following is a simplied version of the problem that I am experiencing when copying a Access 2000 database from one server & client environment to another (live site to disaster recovery site)

Some queries stop running at DR site. Upon investigation it appears that within the design view of a query which has a filter/condition, the quotes are missing e.g.

Select salesperson from sales where Name=Smith

If I view the same query in SQL mode, the where clause is:
where Name="Smith"

If I go back to the design pane and actually insert the quotes and save, the query runs ok.

Is there a generic setting that must be applied to the client at DR site ?

Any help greatly appreciated.

Moben.

 

[PHV]

Same regional settings on both computers ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[moben]

Yes same regional settings.

 

[abdhab]

it could be a problem in the ODBC, check the settings in control panel->administrative tools->data sources(ODBC)