On Tue, 7 Oct 2003 04:18:32 -0700, "Kline" <as**@hotmail.com> wrote:
¤ Could anyone point me to an article that can explain to
¤ me how to create an Access database in code using Visual
¤ Basic .NET?
¤
¤ I really don't want an OLEDB connection .... I want a
¤ private database that simply resides as a file on my
¤ system and is accessed directly by the software I write.
¤ It is NOT intended for the internet or to be read or
¤ written too by anyone over a network.
¤
¤ I also don't want to use any controls that simplify the
¤ process and limit my ability. I want to do it all in code.
You have two choices and both will require COM interop. One uses ADOX (Microsoft ADO Ext 2.x for DDL
and Security) and OLEDB with Jet is required. The other uses the original (and somewhat dated) Jet
database engine layer DAO (no OLEDB is required).
There is no native .NET Jet database engine layer so you will have to rely on the COM objects.
If there is one that you would prefer, post a follow-up and we can come up with an example.
Paul ~~~
pc******@ameritech.net
Microsoft MVP (Visual Basic)