Migrate A2000 queries to A2003

[In a query dude]

I have queries that work fine on a W2K box with A2000 but when I run them on
XP with A2003, they don't work properly. All the data does not display. I
tried converting the database and it seems to work but no query results. I
used another copy, unconverted, and still no results. Does anyone know if
A2003 interpetes all queries from previous versions? I checked the query
builder in both versions and they are identical.

 

[Allen Browne]

Access 2000, 2002, and 2003 all use exactly the same query engine (JET 4.)
There is no reason why A2002 should handle the query differently than A2000.

So, you are looking for differences between those 2 machines. The first
would be to locate msjet40.dll (typically in windows\system32), right-click
and choose Properties. On the Version tab, what version do you see? You
should see 4.0.xxxx.0. If the first x is not an 8 or 9, you need to get the
Jet 4 update from:
http://support.microsoft.com/kb/239114
(Anything from 8000 up is SP8 for JET 4, and there can be slight
differences.)

Also check that both machines have SP3 for Office applied. Check Help |
About. If not, download from:
http://support.microsoft/sp/

If both have SP3 for Office and SP8 for JET 4, see if there is a difference
in Regional Settings (in Windows Control Panel.) For example, a difference
in date format, currency, or list separator could yield different results if
the query is not designed correctly (i.e. handling data types well.)

If you have attached tables, another fairly common mistake is to attach one
of the machines to the wrong data file. You can check this with the Linked
Table manager.

If that doesn't track it down, post the SQL statement (SQL View) of the
simplest query that fails.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...