jet 4.0 vs jet 3.51 : tips and questions

[thebug]

I think you'll find the following things interesting...

I recently developed a project under VB6 using ADO 2.5 Library and Microsoft Jet 3.51. I found out that my application works on every machine with Access 97 installed, but it doesn't works with "clean"
version of Windows 95/98/200/Me. This happens because Windows 95 comes without the Microsoft Jet 3.51 installed, same for Windows 98, and Windows 2000 & Me have Microsoft Jet 4.0 version.

I know that the setup program of my application installs the created Mdac_typ file, but it's a more recent version (newer than the 2.0 version) because of the ADO Library 2.5 linked (and not the ADO Library 2.0). Only the MDAC 2.0 version has Microsoft Jet 3.51 in it, so this is the solution:

Windows 95:
----------
Install DCom95
Install Mdac 2.0
Install your program

Windows 98:
----------
Install Dcom98
Install Mdac 2.0
Install your program

or link your project to the ADO Library 2.0 (older and maybe slower).

If your project is to be installed on Windows 2000/Me systems, then I suggest you to modify (in the connection string) your Provider to Microsoft Jet 4.0. This engine is already installed on Windows 2000/Me systems, and installing an older version (maybe overwriting something of the newer) like Jet 3.51
is not the best thing.

And here comes my questions....

In fact, I want to modify my provider to Jet 4.0, but I found out that the sql strings for opening a recodset are a bit different. For example

select * from Table where Field1='ciao'

works on Jet 3.51, but doesn't work on Jet 4.0, because the right string is:

select * from Table where Field1="ciao"

On the second query I put the double quotes.

My problem is that I can't make the following query work:

select [ID Word] as Found from Table1

The problem is "as Found" because, if I delete it, it works perfectly.

Do you know how can I rename a selected column?
Do you have a link for a paper about these differences between Jet 4.0
and Jet 3.51? Thank you!

[parksie]

On Access 2000 (so it must be Jet 4), I'm using single-quotes and the AS keyword and they work fine