Hello, Is there a way to create a link table without ADOX? Thank you
J John W. Vinson May 26, 2008 #2 Hello, Is there a way to create a link table without ADOX? Thank you Click to expand... Ummmm... yes, several. Use the user interface; use VBA with the (DAO) CreateTable method; run a MakeTable query... Context? What version of Access? What are you trying to accomplish, starting from what, and why the concern about ADOX?
Hello, Is there a way to create a link table without ADOX? Thank you Click to expand... Ummmm... yes, several. Use the user interface; use VBA with the (DAO) CreateTable method; run a MakeTable query... Context? What version of Access? What are you trying to accomplish, starting from what, and why the concern about ADOX?
A Arvin Meyer [MVP] May 26, 2008 #3 Marc R. said: Hello, Is there a way to create a link table without ADOX? Click to expand... Yes, several ways. One way is to use DDL (Data Definition Language) in a SQL statement (query): CREATE TABLE tblContacts ([ContactID] counter, [LastName] text (30), [FirstName] text (30), [ContactDate] date, [Notes] memo, CONSTRAINT [ContactID] PRIMARY KEY ([ContactID]));
Marc R. said: Hello, Is there a way to create a link table without ADOX? Click to expand... Yes, several ways. One way is to use DDL (Data Definition Language) in a SQL statement (query): CREATE TABLE tblContacts ([ContactID] counter, [LastName] text (30), [FirstName] text (30), [ContactDate] date, [Notes] memo, CONSTRAINT [ContactID] PRIMARY KEY ([ContactID]));
