Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

create database

Status
Not open for further replies.

ishikha

Programmer
Mar 22, 2002
36
IN
hi friends,

can u tell me how to create database and tables using coding in vb.i am using ado.
the database i need is access

ishikha

 
I won't give you an answer that you can cut-and-paste, but the following will point you to your answer. You can create databases and tables with VB6 using ADO or via SQL. The following is for ADO

1) Add to references:
ActiveX Data Objects 2.5 Libary
ADO Ext 2.5 for DDL and Security (ADOX)

2) Use ADOX to create the database if it doesn't exist.
Use ADOX to add an empty table shell to a database.
Use ADOX to add formatted columns to a table.

3) Use ADO to load the table.

I strongly recommend the following reference:

msdn.microsoft.com/library/default.asp? (continue next line)
url=/library/en-us/ado270/htm/ (continue next line)
admscadoasp/reference.asp

 
Haveing a sinful time with Ado binding and recordsets with out using the datacontrol can you help?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top