Linked Tables

[wylie3201]

I have inherited a database that has linked tables. I need to add fields and
change structure. Since the tables are linked, I cannot make any changes. How
do I get around this? If I unlink the tables, how will this effect my dbase?

 

[John W. Vinson]

I have inherited a database that has linked tables. I need to add fields and
change structure. Since the tables are linked, I cannot make any changes. How
do I get around this? If I unlink the tables, how will this effect my dbase?

Unlinking the tables will, of course, leave your database with no tables and
no data... probably not what you want!

If you need to change the structure of the linked tables, you need to do so in
the database where the tables reside. Are these in an Access backend database,
in SQL/Server, or in some other storage medium? You can see the tables'
Connect string (indicating the storage medium and location) by hovering the
mouse over the table name in the Tables window, or by opening the VBA window
and typing

?CurrentDb.Tabledefs("SomeTableName").Connect

in the Immediate window.

 

[wylie3201]

Unlinking the tables will, of course, leave your database with no tables and
no data... probably not what you want!

If you need to change the structure of the linked tables, you need to do so in
the database where the tables reside. Are these in an Access backend database,
in SQL/Server, or in some other storage medium? You can see the tables'
Connect string (indicating the storage medium and location) by hovering the
mouse over the table name in the Tables window, or by opening the VBA window
and typing

?CurrentDb.Tabledefs("SomeTableName").Connect

in the Immediate window.

Carolyn

 

[Douglas J. Steele]

They are stored in the SQL server (BE)

In that case, you need to make the changes in SQL Server, not Access. Once
the tables have been changed, it's probably easiest to delete the linked
tables in Access, and relink to the altered tables.