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

sudhi wrote:

First of all thank you very much for your response

Actually I am using VB.Net not the classic VB

I tried the code you suggested , but i am getting an "Invalid
argument". ComException while I try to add the table to the catalog


Any idea why this is happening ?


Yes. your code is attempting to add the primary key to the linked table,
which is illegal (you cannot change the design of linked objects). From
MSDN:

Note Your data provider may not support all properties of Table
objects. An error will occur if you have set a value for a property that
the provider does not support. For new Table objects, the error will
occur when the object is appended to the collection. For existing
objects, the error will occur when setting the property

I don't know of any way to accomplish what you need outside of adding
the primary key to the source table.
--
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: Tcp Port 3367 Established
    ... Microsoft Online Community Support ... The MSDN Managed Newsgroup support offering is for non-urgent issues ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.platformsdk.security)
  • RE: Offer Remote Assistance Not Working
    ... I am sorry for the delayed response due to weekend. ... will cost you time and energy, and we do not support this method in Public ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: DevExpress QuantumGrid 4
    ... > newsgroup where you can get official support within a few hours. ... > You can get unofficial support on the peer-supported Dev Ex newsgroups that ... I finally received a response from support to my specific query (which ...
    (borland.public.delphi.thirdpartytools.general)
  • RE: AIF Filesystemadapter will not write to folder
    ... microsoft.public.platformsdk.security newsgroup. ... I recommend you to use Process Monitor to ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.platformsdk.security)
  • RE: Repost: Outlook 2007: How do I find GlobalObjectID?
    ... Newsgroup account did not take effect at the time, ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework.interop)