[AccessD] changing table in linked backend

Pedro Janssen pedro at plex.nl
Tue Apr 19 16:20:20 CDT 2005


Hi,

is it possible to make a copy of the linked database by code, and change the
name, field name and datatype of this copy?

Pedro


----- Original Message -----
From: "Jim Hewson" <JHewson at karta.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, April 18, 2005 11:28 PM
Subject: RE: [AccessD] changing table in linked backend


> 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
> --
> 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