Adding fields to linked table with code

[Papa_Bear_1352]

Hi all.

What I want to do is write a one off database to insert a field in a linked table preferably not at the end using code.

If I use ALTER TABLE, I get the error "can't do this to a linked table!".

The easiest way would be to talk the users through the change but there are a number of copies and it would be very time consuming

Thanks in advance

 

[AncientOne]

As far as I know, you can't save changes to a linked table's properties. You'd have to import it and re-export it after the changes were made. The feasibility of that would depend on what type of table you were dealing with.

 

[IgorB]

You can use DAO method to talk to database which you link tables from, manipulate with a table structure(alter table).
After you added field use "TransferDatabase" method to relink tables automatically.