Re: Trouble using ADOX to create linked tables in jet database fro

sudhi wrote:
Initially I used MS-Access to create the link tables.
While doing so MS-Access displays the colums in the source table and
asks me to choose a column (or more than one colum) in the source
table as primary key.If I indicate the colum(s) as primary key
MS-Access creates a link table that I can read from and write to.

Yes, that is yet another capability that does not seem to have been
implemented in ADOX (it's not the only functionality that is lacking).
If it's there, I can't find it.

On
the other hand if i did'nt choose a colum then it creates a readonly
link table.I was hoping that if I can add a primary key to the linked
table
programatically then i will create a table that is both readable and
writable.Because I am not able to add this primary key a I get
readonly table. I am wondering how MS-Access is able to add primary
key while I can't do it with ADOX ?


Because ADOX was an afterthought. It was never intended to be a
substitute for Access. MS wanted to deprecate DAO but needed to provide
at least some of the functionality provided by DAO. ADOX was the result.
Frankly, I'm not even sure DAO provided that particular functionality. A
quick browse through the DAO documentation failed to reveal it.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: Access with MySQL resulting Autonumber NOT auto
    ... Because that is how ms-access knows to update the record, ... However, by including BOTH A PRIMARY KEY id, and ALSO A TIME STAMP field, ... Well, you don't need to edit the timestamp field, nor actually place it on ... both the sub-form, and main form - ditto for the primary key id that EACH ...
    (microsoft.public.access.modulesdaovba)
  • Re: Write Conflict! Cant save a record.
    ... make sure the table in question has primary key, ... make sure the tale in question has a timestamp field, ... exposed to ms-access. ... Albert D. Kallal (Access MVP) ...
    (microsoft.public.access.forms)