Programming Forums
User Name Password Register
 

RSS Feed
FORUM INDEX | TODAY'S POSTS | UNANSWERED THREADS | ADVANCED SEARCH

Reply
 
Thread Tools Display Modes
Old Aug 2nd, 2006, 4:22 AM   #1
kruptof
Professional Programmer
 
kruptof's Avatar
 
Join Date: May 2006
Location: UK - London
Posts: 329
Rep Power: 3 kruptof is on a distinguished road
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.
__________________
Quote:
When I was young it seemed that life was so wonderful,a miracle, oh it was beautiful, magical.
Now watch what you say or they'll be calling you a radical,a liberal, oh fanatical, criminal. Oh won't you sign up your name,we'd like to feel you're acceptable, respectable, oh presentable, a vegetable
kruptof is offline   Reply With Quote
Old Aug 3rd, 2006, 12:13 AM   #2
Booooze
Expert Programmer
 
Booooze's Avatar
 
Join Date: Mar 2006
Location: Igloo
Posts: 710
Rep Power: 3 Booooze is on a distinguished road
Send a message via MSN to Booooze
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:
vb6 Syntax (Toggle Plain Text)
  1. cmd.CommandText = "create table tnn1 (a varchar(10), b number)"

Where cmd is

vb6 Syntax (Toggle Plain Text)
  1. Dim cmd As New ADODB.Command
Booooze is offline   Reply With Quote
Reply

Bookmarks

« Previous Thread in Forum | Next Thread in Forum »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
test lostcauz Coder's Corner Lounge 9 Jul 18th, 2006 3:20 PM
[beginner] how to reverse the contents of a table mariogarcia Java 4 Nov 4th, 2005 3:12 AM
How to connect with VB to an Access database on another computer iown714 Visual Basic 5 Aug 4th, 2005 10:23 AM
word wrap in a table cell? kerriganm HTML / XHTML / CSS 4 May 6th, 2005 5:38 PM




DaniWeb IT Discussion Community
All times are GMT -5. The time now is 5:13 PM.

Powered by vBulletin® Version 3.7.0, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Copyright ©2007 DaniWeb® LLC