Access database question

[Eddie]

Hi,

Is it possible to create an Access database using ADO.net
and VB.net? Along with encrypting it etc. If so can
someone point me to a site or offer some code to get me
started.


Thanks in advance.

Eddie

 

[CT]

ADO.NET doesn't give you the functionality of the COM based ADOX. However,
you can still use ADOX through COM Interop. Chekc out these pages:
http://www.able-consulting.com/ADOX_Faq.htm#Q2
http://www.4guysfromrolla.com/webtech/013101-1.shtml

 

[Cor]

Hi Eddie,

You cannot direct using ADO.NET but you can create a access database by

set a reference to COM adox ext 2.x for dll and security
\\\
Dim catNewDB As ADOX.Catalog
catNewDB = New ADOX.Catalog
catNewDB.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data
Source=C:\db1.mdb")
///

I hope this helps a little bit?

Cor

 

[George Shubin]

Try this:
http://www.doitin.net/dbcopier.aspx

Works great and it's free.


--