Linked Tables

  • Thread starter Thread starter wylie3201
  • Start date Start date
W

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?
 
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?
Click to expand...

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.
 
John W. Vinson said:
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.
Click to expand...
Carolyn
 
wylie3201 said:
They are stored in the SQL server (BE)
Click to expand...

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.
 
Back
Top