ADOX, Jet OLEDB 4 & Access 97 .mdb 
Author Message
 ADOX, Jet OLEDB 4 & Access 97 .mdb

Is it possible to create an Access 97 .mdb file using ADOX with
Jet.OLEDB.4.0 or can it only be done via Jet.OLEDB.3.51?

Thanks.

Jim



Sat, 29 Nov 2003 03:32:12 GMT  
 ADOX, Jet OLEDB 4 & Access 97 .mdb
On Mon, 11 Jun 2001 20:32:12 +0100, "Jim McColm"

Quote:

>Is it possible to create an Access 97 .mdb file using ADOX with
>Jet.OLEDB.4.0 or can it only be done via Jet.OLEDB.3.51?

>Thanks.

>Jim

As far as I know, you need to use the 3.51 provider to create an
Access97 database.

Interesting thing is the compact method in the JRO library can be used
with Jet.OLEDB.4.0 to convert an Access database to any version of
Access ( 1.0, 1.1, 2.0, 95, 97,  and Access2000).

Richard.



Sat, 29 Nov 2003 12:26:44 GMT  
 ADOX, Jet OLEDB 4 & Access 97 .mdb
Hi
You can use Jet,OLEDB.4.0 to create an access database.
Using Jet 4.0 the deafult Engine Type is 5 - which creates
an Access 2000 database. But at the end of your connection
string, if you specify OLEDB Jet Engine Type = 4 then this
will create an Access 97 database.

Check out website www.4guysfromrolla.com/webtech/013101 -
1.shtml

N Savjani

Quote:
>-----Original Message-----
>On Mon, 11 Jun 2001 20:32:12 +0100, "Jim McColm"

>>Is it possible to create an Access 97 .mdb file using
ADOX with
>>Jet.OLEDB.4.0 or can it only be done via Jet.OLEDB.3.51?

>>Thanks.

>>Jim

>As far as I know, you need to use the 3.51 provider to
create an
>Access97 database.

>Interesting thing is the compact method in the JRO
library can be used
>with Jet.OLEDB.4.0 to convert an Access database to any
version of
>Access ( 1.0, 1.1, 2.0, 95, 97,  and Access2000).

>Richard.
>.



Fri, 12 Dec 2003 19:17:28 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Microsoft.Jet.OLEDB.4.0 Provider not working with Access 97 MDB

2. ADOX, Access 2000 and Jet OLEDB property settings

3. Can't Access Users collection in ADOX (Jet OLEDB)

4. Jet.oledb provider with Access 97

5. ADOX & MDW from Access 97

6. TransferDatabase method from Access 95 mdb to Access 97 mdb

7. How to set Format property in ACCESS2k thru ADOX using JET OLEDB 4.0 provider

8. ADOX: Jet Oledb 4.0: How to set Format property for a column

9. ADOX, Jet OLEDB:Allow Zero Length ERROR...

10. Jet OLEDB & Access databases with passwords

11. Repost: Word 97 and the Jet (Access 97)

12. Procedures for Converting an Access 97 MDB to Access 2002

 

 
Powered by phpBB® Forum Software