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
|
|||
|
|||
SQL Refresh
After upsizing my 3 tables to a SQL server I think that I have to refresh the linked tables manually. Is this right? Shouldn't it happen automatically?
|
#2
|
|||
|
|||
SQL Refresh
Hi JMorrell,
Refresh all table links without having to delete the link and recreate it. 1.)To do this, under the Tools menu, select "Database Utilities" and then "Linked Table Manager." 2.)A Linked Table Manager window should appear as follows: 3.) Select the tables that you wish to refresh the links for. In this example, we've selected the Employees table. Click on the OK button. 4.)You should get a message indicating that the linked tables were successfully refreshed. Now, any changes to the linked table should be reflected in your database. Please let me know has this helped You... Thank you... Raghu... This posting is provided "AS IS" with no warranties, and confers no rights. |
#3
|
|||
|
|||
SQL Refresh
Thank you Raghu,
I've gone through this routine and the tables get refreshed just fine. I Do suspect though, that subsequent to that refresh process, data is not getting updated to the SQL server. Have not been able to discern a pattern to this. I will keep looking, and watching. thanks again. JMorrell |
#4
|
|||
|
|||
SQL Refresh
"JMorrell" ¼¶¼g©ó¶l¥ó ... After upsizing my 3 tables to a SQL server I think that I have to refresh the linked tables manually. Is this right? Shouldn't it happen automatically? |
Thread Tools | |
Display Modes | |
|
|