Create DB without ADOX

[Tink]

I have Googled this topic to death to the best of my ability and hope that
somebody here can help.

I do not want to have any COM dependencies in a project. For various
reasons, the application will use an Access database. Unfortunately, it
appears ADO.NET does not allow you to create a database and tables.
Everything I have seen seems to point to ADOX, but that requires an ActiveX
component which I extremely want to avoid.

Does anybody know how to programmaticall y create an Access DB and tables in
that DB without using a COM object?

Thanks in advance for any help.

[Cowboy \(Gregory A. Beamer\) [MVP]]

The issue is not creating tables, as Ican send DDL to every database I have
worked with without problem. The issue is creating the original database. To
completely avoid COM, you end up creating a database template (.mdb with no
tables) and copying it where you need it. You can then add objects to the
database, as long as they are definable in SQL (for example, forms are
objects you cannot write out in SQL, so you have to use Access objects (COM)
to set them up).

NOTE: I have not dinked fully with the Office .NET components. With these,
you may be able to do more of the creation, etc., of Office docs and files.
You note this is aimed at Office 2003 (maybe XP?), so it is not applicable
to all versions.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************** *************** *************** ***
Think Outside the Box!
*************** *************** *************** ***
"Tink" <Ti**@discussio ns.microsoft.co m> wrote in message
news:45******** *************** ***********@mic rosoft.com...

I have Googled this topic to death to the best of my ability and hope that
somebody here can help.

I do not want to have any COM dependencies in a project. For various
reasons, the application will use an Access database. Unfortunately, it
appears ADO.NET does not allow you to create a database and tables.
Everything I have seen seems to point to ADOX, but that requires an ActiveX component which I extremely want to avoid.

Does anybody know how to programmaticall y create an Access DB and tables in that DB without using a COM object?

Thanks in advance for any help.

[Cowboy \(Gregory A. Beamer\) [MVP]]

The Access objects are definitely easier, but unless the Office .NET
components are complete in that area, you end up with some Interop.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************** *************** *************** ***
Think Outside the Box!
*************** *************** *************** ***
"Tink" <Ti**@discussio ns.microsoft.co m> wrote in message
news:38******** *************** ***********@mic rosoft.com...

Greg,

I should have noted that I was aware I could copy a database template, but I was not fully aware that tables and their structure could be done using ..NET technologies. Unfortunately, I will have to Google/MSDN that as I am pretty lame at SQL.

Thanks though - that is a better solution than copying a complete database
template IMHO.
Tink

[Paul Clement]

On Thu, 19 Aug 2004 05:43:04 -0700, "Tink" <Ti**@discussio ns.microsoft.co m> wrote:

¤ I have Googled this topic to death to the best of my ability and hope that
¤ somebody here can help.
¤
¤ I do not want to have any COM dependencies in a project. For various
¤ reasons, the application will use an Access database. Unfortunately, it
¤ appears ADO.NET does not allow you to create a database and tables.
¤ Everything I have seen seems to point to ADOX, but that requires an ActiveX
¤ component which I extremely want to avoid.
¤
¤ Does anybody know how to programmaticall y create an Access DB and tables in
¤ that DB without using a COM object?
¤
¤ Thanks in advance for any help.

There is no way to eliminate COM dependencies from this process, and you're not adding an ActiveX
component since your project will still be dependent upon MDAC and Jet (for an Access database) if
you are using OLEDB.
Paul ~~~ pc******@amerit ech.net
Microsoft MVP (Visual Basic)