Access97 mdb creation from VB.NET

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NullRef - 19 Oct 2004 21:17 GMT

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!

Reply to this Message

Scott M. - 19 Oct 2004 23:15 GMT

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
[quoted text clipped - 7 lines]
> Thanks in advance.
> Cheers!

Reply to this Message

Paul Clement - 20 Oct 2004 16:50 GMT

¤ 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 ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Reply to this Message

Scott M. - 20 Oct 2004 23:10 GMT

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.

> ? Hello - I'm trying to create an ACCESS97 database MDB as well as tables
> w/in
[quoted text clipped - 13 lines]
> Paul ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)

Reply to this Message

Paul Clement - 27 Oct 2004 18:18 GMT

¤ 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 ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Reply to this Message

Access97 mdb creation from VB.NET

Free Magazines