[AccessD] changing table in linked backend

Jim Hewson JHewson at karta.com
Mon Apr 18 16:28:40 CDT 2005


I would create a query and change the name there.
In the design view field row, you can add the new name with a colon after it, followed by the actual name of the field.
In SQL it's something like: 
SELECT tblLinked.OldID as NewID
Don't add any calculations, group by, etc. 
You can change the format, but sometimes that's not too useful.
Then use the query as you would a table with the new names.

HTH
Jim 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Pedro Janssen
Sent: Monday, April 18, 2005 3:53 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
>


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list