Create a Table using VB How can i create a table using nothing but code. Thanx
H harrisw Registered User. Local time Today, 15:39 Joined Mar 27, 2001 Messages 131 Jan 7, 2004 #1 Create a Table using VB How can i create a table using nothing but code. Thanx
crosmill Registered User. Local time Today, 15:39 Joined Sep 20, 2001 Messages 285 Jan 7, 2004 #2 You'd need use SQL and then execute the SQL in VBA docmd.RunSQL (CREATE TABLE TableName)
Oldsoftboss AWF VIP Local time Tomorrow, 00:39 Joined Oct 28, 2001 Messages 2,499 Jan 8, 2004 #3 This example creates a table, a couple of fields and sets the autonumber and primary key field. HTH Dave Attachments creating a table.zip 21.5 KB · Views: 179
This example creates a table, a couple of fields and sets the autonumber and primary key field. HTH Dave
H harrisw Registered User. Local time Today, 15:39 Joined Mar 27, 2001 Messages 131 Jan 21, 2004 #4 How do I do this using ADO and not DAO? Many Thanks
Travis Registered User. Local time Today, 07:39 Joined Dec 17, 1999 Messages 1,332 Jan 21, 2004 #5 HOWTO: Create a Table with Primary Key Through ADOX