[AccessD] changing table in linked backend

Stuart McLachlan stuart at lexacorp.com.pg
Tue Apr 19 17:01:10 CDT 2005


On 19 Apr 2005 at 23:20, Pedro Janssen wrote:

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

One way would be to create a new table with the desired format either 
directly in your application database or or in a separate "backend" 
database and link to that as well as to the original table.  Then 
periodically run two queries , a delete query to clear  your new table  
followed by an Insert query of all the records from the old table into the 
new table.

If there is a unique key in the old table, you can set a unique index on  
that field in the new table and forget about the delete query.

Note that if you are doing this frequently, you will have to compact the 
database regularly or you will get very bad bloat. 




-- 
Stuart





More information about the AccessD mailing list