[slinkelist] access can't open new .mdb

[Sonnie]

The way I understand it is that if omitted it will use OLEDB Jet version 5,

Meaning upgrade the database to JET 4.X
So you'd probably want to set it to OLEDB Version 4 to keep it at JET 3.X

Microsoft made this very confusing indeed.... I'll take this offline with
you...

cheers,

Jeroen

-----Original Message-----
From: slinkelist-admin@nirvis.com [mailto:slinkelist-admin@nirvis.com]On
Behalf Of Colby Boles
Sent: Monday, April 24, 2000 7:38 AM
To: Sonnie; Colby Boles; slinkelist@nirvis.com
Subject: RE: [slinkelist] access can't open new .mdb


I'm a little confused now. My impression from the MSDN docs (see below) is
that if I *don't* specify what jet version to write out using the "Jet
OLEDB:Engine Type=" setting in the compaction process, I should end up with
the same version I started with. Does anyone know why this isn't working?

(from the docs)

Jet OLEDB:Engine Type   Indicates the version of the source database to open
or the version of the new database to be created. The OLE DB engine types
that you can use are:
1 for JET Version 1.0

2 for JET Version 1.1

3 for JET Version 2.x

4 for JET Version 3.x

5 for JET Version 4.x

If this is omitted for the destination database, it will be the same version
as for the source database. The value for the destination database cannot be
a version prior to that of the source database.





_______________________________________________
slinkelist maillist  -  slinkelist@nirvis.com
http://www.nirvis.com/mailman/listinfo/slinkelist