Access97 mdb creation from VB.NET

[NullRef]

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!

[Scott M.]

I've heard of something called ADOX that can create the db and tables. From
there ADO.NET allows you to modify the db.

"NullRef" <Nu*****@discussions.microsoft.com> wrote in message
news:98**********************************@microsof t.com...

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!

[Paul Clement]

On Tue, 19 Oct 2004 13:17:01 -0700, "NullRef" <Nu*****@discussions.microsoft.com> wrote:

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

[Scott M.]

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.


"Paul Clement" <Us***********************@swspectrum.com> wrote in message
news:b4********************************@4ax.com...

On Tue, 19 Oct 2004 13:17:01 -0700, "NullRef"
<Nu*****@discussions.microsoft.com> wrote:

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

[Paul Clement]

On Wed, 20 Oct 2004 17:10:26 -0500, "Scott M." <No****@NoSpam.com> wrote:

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