Re: Changing linked SQL Server tables in code

Rich P wrote:
Hi Bruce,

Relinking ODBC tables in code is kind of a pain. This is a downside
of ODBC. If the tables were purely static then ODBC is an easy
solution, but whenever you need to make something even just a little
bit mroe dynamic - ODBC becomes a real hassel.

Please elaborate. I never have any difficulty changing ODBC links. Loop
through the objects, set the connect property. What is difficult about
that?

ADO is a much easier
option to go with as far as using Code for manipulating data from Sql
Server Tables. With ODBC you have to use a lot of API code.

API code? No idea what you mean here.

With ADO
you just make a reference to the Microsoft ActiveX DataObjects
library (2.5 or higher) and you can find tons of sample of code on
the Net.

Or just set the connect property with ODBC. Doesn't even require a
reference.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: help pls.........
    ... If the forms are in the WB, then there's no need for any ODBC etc stuff. ... You can reference the WS directly. ... I have a workbook named WBOOK with I think 20 worksheets. ... What I want to do is to be able to edit and delete data from worksheets ...
    (microsoft.public.excel.programming)
  • Re: OdbcDataAdapter and MySQL
    ... Don't use Microsoft.Data.Odbc reference; ... Configure the driver in Control Panel>Administrative Tools>Data ... Select "System DSN">Add>MySQL ODBC 3.51 Driver DSN. ... specifically MyISAM types. ...
    (microsoft.public.dotnet.languages.csharp)
  • Linked Tables odbc
    ... I have a BE that links via odbc to sql. ... The database is obviously split. ... does the FE reference the BE and then link to sql via ...
    (microsoft.public.access.tablesdbdesign)
  • Re: ODBC
    ... Where to find a reference to ODBC attributes? ... I dont know how to enable Integrated Security ...
    (microsoft.public.dotnet.languages.csharp)