access

[Guest]

Hi;

How do I create an access database programatically,
in vb.net? I need to programatically create the .mdb, and
the table, and column names, as string type columns.

I referenced an access.dll

Articles?

Segue

 

[Cor Ligthert [MVP]]

Seque,

Have a look at our website.

http://www.vb-tips.com/default.aspx?ID=e76b8450-4c8a-4662-8f41-d6dda3c888c8

I hope this helps,

Cor

 

[Herfried K. Wagner [MVP]]

How do I create an access database programatically,
in vb.net? I need to programatically create the .mdb, and
the table, and column names, as string type columns.

See:

HOW TO: Create a Microsoft Access Database Using ADOX and Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;317867>

 

[Guest]

I create access databases using the connection stirng:

cat.Create("Provider=Microsoft.Jet.OLEDB.4.0; Data _
Source=D:\AccessDB\NewMDB.mdb)

I leave off the ";Jet OLEDB:Engine Type=5" that is shown in the example.
What does this part do in creating the database?

 

[Paul Clement]

¤ I create access databases using the connection stirng:
¤
¤ cat.Create("Provider=Microsoft.Jet.OLEDB.4.0; Data _
¤ Source=D:\AccessDB\NewMDB.mdb)
¤
¤ I leave off the ";Jet OLEDB:Engine Type=5" that is shown in the example.
¤ What does this part do in creating the database?

It specifies the version of the Jet database storage engine to use, although it isn't of any
significance when *creating* an Access database.


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Guest]

Thanks to all this was easier than I thought.

Still don't know how to use the access.dll I referenced.

 

[Guest]

Thanks to all this was easier than I thought.

Still don't know how to use the access.dll I referenced.

 

[Guest]

Thanks to all this was easier than I thought.

Still don't know how to use the access.dll I referenced.

 

[Guest]

Thanks. If I don't specify it when creating then I assume the latest version
on my computer will be used...is this correct? Also, when accessing the
database if I don't specify the type, then also the latest version will be
used..is this also correct?