microsoft jet engine 3.51

[asi]

hello everybody
i m trying to work with access2000 but i have a problem with the jet engine and i know that i need to replace it to jet 4.0 but will jet 4.0 work with my access97 databases? if it would what should i do to make it work ?

[RSINGH]

As far as I know, both versions will not work on the same machine.

[asi]

what do you mean ? access97 and access2000 wont work on the same machine ?

[RSINGH]

yup!

[oh1mie]

Originally posted by asi
hello everybody
i m trying to work with access2000 but i have a problem with the jet engine and i know that i need to replace it to jet 4.0 but will jet 4.0 work with my access97 databases? if it would what should i do to make it work ?

Engine Type=5 =Access 2000 format, Engine Type=4 = Access 97 ... 
"PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDatabase.mdb" & _ 
";Jet OLEDB:Engine Type=4"

oh1mie/Vic

[VBKNIGHT]

Well if your using Access2000 you would not have a problem accessing Access97. Just use lower jet engine version on 97.

[asi]

does the jet 4.0 work with access97?

[asi]

ok i know that i should use the 3.51 for access97 but i need them both and i dont want to put them both on my project so i just need to know if the jet 4.0 can work with access 97

[VBKNIGHT]

certainly not! either you convert the 97 to 2000 or use Jet 3.5 on 97.

[jig]

Developing an application to access both Access97 and Access2000 will work with the 4.0 jet engine. There are a COUPLE of things to watch out for, such as compacting and repairing(4.0 and 3.51 work totally DIFFERENT in this aspect), but other that that you should be ok.

Otherwise, you cannot have both access97 and access2000 installed on your computer unless your using multiple OS.