Link table

[Marc R.]

Hello,

Is there a way to create a link table without ADOX?

Thank you

 

[John W. Vinson]

Hello,

Is there a way to create a link table without ADOX?

Thank you

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?

 

[Arvin Meyer [MVP]]

Hello,

Is there a way to create a link table without ADOX?

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]));