Programming Forums - Adding New Access Table

Programming Forums (http://www.programmingforums.org/forumindex.php)

- Visual Basic (http://www.programmingforums.org/forum18.html)

- - Adding New Access Table (http://www.programmingforums.org/showthread.php?t=10917)

kruptof

Aug 2nd, 2006 4:22 AM

Adding New Access Table

Does anybody know to how to add a new table to an Access DataBase which has already 3 pre-existing tables..........i am using the DAO control to interact with the database.

Booooze

Aug 3rd, 2006 12:13 AM

Never really bothered with access, but the method you use depends on which way you have coded how you connect to the db. the other really important things to look into are which version you are using. I've googled it, and here is what I found:

http://forums.aspfree.com/visual-bas...ing-39306.html

Note the:

cmd.CommandText = "create table tnn1 (a varchar(10), b number)"

Where cmd is

Dim cmd As New ADODB.Command

All times are GMT -5. The time now is 5:33 PM.