Altering linked tables

Y

Yair Sageev

Greetings,

I am using an Access mdb with all linked tables in MSDE. I know that you
can't change linked tables from the MDB, so I created an ADP that imports
all the tables, so that I can alter them in the ADP. The ADP let's me add a
column to a table, but when I open the mdb up again that column isn't there.

What do I do?

Thanks in advance.
 
6

'69 Camaro

Hi, Yair.

Drop the link, then recreate the link to the table. An external table's
structure and connection properties are only recorded at the time of
linking, so any later changes that you make to a linked table's structure
(i.e., add/change/delete/rename fields) or connection properties (i.e.,
add/change/delete database password) are unknown. Dropping and recreating
the link will re-establish the correct properties needed to access the data
in the external table.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
 
Y

Yair Sageev

Thanks Gunny.

How do I drop the link and relink?

Will it affect all my forms and reports?

I'll check the help too but if it's an easy answer...
 
Y

Yair Sageev

Thanks. I used the linked table manager to refresh the tables an it worked
perfectly.
 
6

'69 Camaro

Hi, Yair.

How do I drop the link and relink?
Click to expand...
Select the linked table in the database window with your mouse and hit the
<DELETE> key. Then use the menu "File -> Get External Data -> Link Tables"
and browse for the file that contains the table that you want to link to,
then follow the prompts in the dialog window just like you did when you
originally linked the table.
Will it affect all my forms and reports?
Click to expand...
Sort of. It will allow you to add this new field to all of the forms and
reports bound to this table, and any queries and Recordsets that utilize the
table, but won't automatically make these changes for you.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
 
Top