Access97 mdb creation from VB.NET

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello - I'm trying to create an ACCESS97 database MDB as well as tables w/in
the db all programatically from VB.NET -- is this possible? I've seen
examples for creating Access2000 database using interop w/ "Microsoft ADO
Ext. 2.7 for DDL and Security" BUT I cannot seem to open w/ Access07, is
there another approach I can use?

Any thoughts?

Thanks in advance.
Cheers!
 
I've heard of something called ADOX that can create the db and tables. From
there ADO.NET allows you to modify the db.
 
¤ Hello - I'm trying to create an ACCESS97 database MDB as well as tables w/in
¤ the db all programatically from VB.NET -- is this possible? I've seen
¤ examples for creating Access2000 database using interop w/ "Microsoft ADO
¤ Ext. 2.7 for DDL and Security" BUT I cannot seem to open w/ Access07, is
¤ there another approach I can use?
¤
¤ Any thoughts?

You need to specify the correct database engine type (Jet OLEDB:Engine Type). The value should be 4
for an Access 95/97 database.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Are you referring to the OLEDB version (as in
Provider=Microsoft.JET.OLEDB.4.0)?

If so, I was always under the impression that for Access 95/97 the correct
version was 3.51 (although 4.0 will work) and for Access 2000 or higher it
was 4.0.
 
¤ Are you referring to the OLEDB version (as in
¤ Provider=Microsoft.JET.OLEDB.4.0)?
¤
¤ If so, I was always under the impression that for Access 95/97 the correct
¤ version was 3.51 (although 4.0 will work) and for Access 2000 or higher it
¤ was 4.0.
¤

No I was referring to the Engine Type parameter and not the Provider.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top