Table created but not visible?

R

rotor

Hello, Okay, I'm new

I ran the following code which creates a simple table, but when it's done, the table is not visible. What else do I need to do to make this table visible

Dim strSQL As Strin

strSQL = "CREATE TABLE TestTable1
strSQL = strSQL & "(TestField1 INTEGER CONSTRAINT pk PRIMARY KEY,
strSQL = strSQL & "TestField2 VARCHAR(5) NULL)

CurrentDb.Execute strSQ

Thanks in advance for the assistance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't seem to retrieve primary key number of newly created record in VB 1
cannot delete from specified tables 7
Change a report to a query 1
insert into table 2 fields instead of one 5
Append current record to table 6
MakeSchedule function 6
Make table from recordset 2
Comparing multi select list box criteria against two fields 4

Top