|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
creating table from vb
Hi,
I'm a student.I'm using vb 6 and access 2000.I'm creating a table in access by executing a query in vb.How can I know that is there any table with the same name already exists?If it exists how I can overwrite it Pls any body help Thnx in advance Nebu |
|
#2
|
|||
|
|||
|
select * from MsysObjects where name = 'table1'
Or: on error resume next myconnection.execute "drop table table1" on error goto 0 myconnection.execute "create table table1 (field1 int)" Last edited by madmatt75 : January 6th, 2004 at 12:06 PM. |
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > creating table from vb |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|