Create a ADO database (runtime)?

How can I create a database, table and fields, append information on that fields and close it?

I'm working with VB 6, ADO, with access.
thanks
asimoesAsked:
Who is Participating?
 
MarineConnect With a Mentor Commented:
You will have to use ADOX to do this. And work with it's Tables Class define columns collection and work from that. Visit this link has tutorials.
http://msdn.microsoft.com/library/officedev/odeopg/deovrcreatingmodifyingaccesstables.htm
And for more additional info here is another link. The provide great sample codes.
0
 
Éric MoreauSenior .Net ConsultantCommented:
0
 
asimoesAuthor Commented:
What about the rest of the code writen with ADO?
Should I change all the code to work with databases into the new structure that ADOX brings?

Thanks
0
 
MarineCommented:
ADOX only allows you to work with table structures i would think. Where as ADO has all the necessary tools for you to navigate though tables and perform actions on it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.