If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linked Table
If I add a new field/Columnin the table to the back-end of a split database,
would that new field/column show in the linked table on the fron-end? If not, how do I add a new column without breaking the link? Thanks. Joe |
#2
|
|||
|
|||
Linked Table
Joe
The "link" in the front-end is a description for Access to use to know how to find, what to look for... When you move the cheese in the back-end, the front-end doesn't know you did that. You need to refresh the link so the front-end knows how to find, what to look for... Use the Linked Table manager to refresh that link. Regards Jeff Boyce Microsoft Office/Access MVP "Joe" wrote in message ... If I add a new field/Columnin the table to the back-end of a split database, would that new field/column show in the linked table on the fron-end? If not, how do I add a new column without breaking the link? Thanks. Joe |
#3
|
|||
|
|||
Linked Table
On Tue, 21 Oct 2008 13:49:01 -0700, Joe wrote:
If I add a new field/Columnin the table to the back-end of a split database, would that new field/column show in the linked table on the fron-end? If not, how do I add a new column without breaking the link? Thanks. Joe In my experience, even though the linked table manager may think it's fixed the link there are often wierd errors. It's probably better to delete the table icon in the frontend (the link) and use File... Get External Data... Link to reconnect to the redesigned table. There's no harm do deleting the link and recreating it. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Linked Table
Thank Jeff,
The reason I worded my question that way that I did is becuse the "refresh" was not working. I refreshed the tables link several times but the new column did not show in the front-end. I will just deleted the link and create it again. Thanks. "Jeff Boyce" wrote: Joe The "link" in the front-end is a description for Access to use to know how to find, what to look for... When you move the cheese in the back-end, the front-end doesn't know you did that. You need to refresh the link so the front-end knows how to find, what to look for... Use the Linked Table manager to refresh that link. Regards Jeff Boyce Microsoft Office/Access MVP "Joe" wrote in message ... If I add a new field/Columnin the table to the back-end of a split database, would that new field/column show in the linked table on the fron-end? If not, how do I add a new column without breaking the link? Thanks. Joe |
#5
|
|||
|
|||
Linked Table
Thanks John,
I think your solution is the best one because I had, prior to posting the question, refreshed the link tables and the new column in the back-end still did not show in the front-end. Thanks again. Joe "John W. Vinson" wrote: On Tue, 21 Oct 2008 13:49:01 -0700, Joe wrote: If I add a new field/Columnin the table to the back-end of a split database, would that new field/column show in the linked table on the fron-end? If not, how do I add a new column without breaking the link? Thanks. Joe In my experience, even though the linked table manager may think it's fixed the link there are often wierd errors. It's probably better to delete the table icon in the frontend (the link) and use File... Get External Data... Link to reconnect to the redesigned table. There's no harm do deleting the link and recreating it. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|