During the developement of one of my database projects I found out the following things:
If you use ADO library 2.5 in your project and the Jet.OLEDB.3.51 Provider in your ADODB.Connections, you must be sure that Jet 3.51 is correctly installed on the target machine.
Your project will work on any system with Access 97, but it will not work on "clean" Windows 95/98 and it will NOT work on Windows 2000 or ME because they have Jet 4.0 ONLY (tell me if i'm wrong, but I tried this by myself on multiple machines).
I recommend you that if you want to install your project on Windows 2000/ME you should update your code for supporting Jet 4.0. It's not recommended to install Jet 3.51 (older version) on Jet 4.0 (newer).
If you want to install your code on Windows 95/98, that's perfect, but you have to install (after Dcom 95/98) the Mdac 2.0 file. Only the 2.0 version has Jet 3.5/3.51. The most recent version of MDAC does not contain the Jet provider.
And now the question....
I want to update my code from Jet 3.51 to Jet 4.0, but I found out that the sql-language is a bit different! I must correct my queries, but how? Look at this, this query works perfectly on Jet 3.51 engine:
but it won't work on Jet 4.0!! I think that the problem is the "as Found" because if I delete it, the query works perfectly.Code:select [Word ID] as Found from Words
I found out by myself that the "where" clause is a bit different:
I don't have Access 2000 for cutting and pasting queries. maybe you have? can you solve my problem?Code:where a="string" JET 4.0
where a='string' JET 3.51
Does anyone knows a good Access 2000 SQL Reference link?
