Re: Changing a linked table's Connect property just with SQL

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in message
news:eF4XKDBgHHA.4032@xxxxxxxxxxxxxxxxxxxxxxx

It's not possible to do that using SQL: the Connect property isn't
accessible through SQL.

Ah... that's a shame.

See whether you can use ADOX to do it. The property of the Table object in
which you're interested is "Jet OLEDB:Link Datasource"

I'm really trying to avoid COM if at all possible - this is a .NET app which
needs to run on both WinXP Pro and Vista Business, neither of which will
have any version of Office installed.

Am I right in thinking that ADOX is not part of the standard build of either
of these to operating systems...? If so, can it be installed independently
of ADO...?


.

Relevant Pages

  • Re: Should chrisitans vote for politians who promote homosexuality?
    ... The important thing was to avoid the shame of having a guest harmed. ... rather than avoiding harm, then so much the worse for them. ...
    (uk.religion.christian)
  • Re: Update Query (multiple fields)
    ... One day I'll publish an article on why I prefer to avoid Nz. ... JET has a native IIf() so it avoids a call to VBA. ... Also the native JET IIf() gets the data types right, whereas JET does not interpret the data type returned by Nz- and any other VBA functions that returns a Variant. ... > If this is too convoluted, I'll just do a query for each field. ...
    (microsoft.public.access.queries)
  • Re: I need java floppy sized
    ... >executable with Jet that does not even need a runtime. ... You might have to avoid any sort of GUI interface to squeeze it into ... Coaching, problem solving, economical contract programming. ...
    (comp.lang.java.programmer)
  • ?? for Conservatives Fear or Elitism
    ... avoid military service and especially military service in time of war, ... is it an inherent Un American cowardice when compared to the real patriots ... into self serving, self obsessed, greedy,selfish, unpatriotic traitors, who ... have you no shame ...
    (soc.retirement)
  • Re: JET bandsaw update
    ... Shame on Jet for letting you do that, ... Given the above, the reviews of the JET by users, almost exclusively were 5 star, vs only *mostly* 5 star for others like Grizzly and Delta. ... But humiliation? ...
    (rec.woodworking)