[AccessD] changing table in linked backend

Hi,

so i can't make an autoexec macro that changes these items by code.

When this isnt possible, what is the best thing to do then??


Pedro Janssen


----- Original Message -----
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, April 18, 2005 10:01 PM
Subject: RE: [AccessD] changing table in linked backend


> You can't.  Design changes can only be made in the table itself, which
> means the original table.  The linked table is just an aliased pointer
> to the original.
>
> Charlotte Foust
>
>
> -----Original Message-----
> From: Pedro Janssen [mailto:pedro at plex.nl]
> Sent: Monday, April 18, 2005 12:05 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] changing table in linked backend
>
>
> Hello Group,
>
> i have a backend database that has a linked table from another database,
> that is made by a firm (No adjustments can be made in the original
> table).
>
> How can i change the tables name, the name of the ID field and the
> datatype in number in the linked table.
>
> Pedro Janssen
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>