Re: How to programmatically refresh linked tables

Per bubbles:
The tables will be added dynamically at the SQL Server end when new
products
comes into existance -- this product info is pulled from another
remote server
periodically. When new products come into existance in the remote
server,
a TSQL statement will create the new tables.

That is why I am trying to find a way to link these tables
programatically, without
user intervention.

Would it be correct to assume that the format of the new tables
is identical to the format of some table that the application is
already reading?

Like maybe there's a table for each product - with a common
"product information" format?
--
PeteCresswell
.

Relevant Pages

  • Re: How to programmatically refresh linked tables
    ... users will not be expected to modify the design. ... comes into existance -- this product info is pulled from another ... When new products come into existance in the remote ...
    (comp.databases.ms-access)
  • Re: How to programmatically refresh linked tables
    ... The tables will be added dynamically at the SQL Server end when new ... comes into existance -- this product info is pulled from another ... When new products come into existance in the remote ...
    (comp.databases.ms-access)
  • Re: format of service principal name (SPN)
    ... credentials to a remote server fails because the remote server receives the ... We need to set up the service principal name for a service in this format ... we use object guid what format do we enter that? ...
    (microsoft.public.windows.server.security)
  • Convert Date pb
    ... The remote server has regional settings set to "en-UK" and date to ... the following format yyyy-mm-dd. ... convert the string date he filled to yyyy-mm-dd regarding this format? ...
    (microsoft.public.dotnet.languages.csharp)
  • Date conversion pb
    ... Got and add-in for Excel which call functions from a web service (on a ... The remote server has regional settings set to "en-UK" and date to ... the following format yyyy-mm-dd. ...
    (microsoft.public.dotnet.languages.vb)