A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

SQL Refresh



 
 
Thread Tools Display Modes
  #1  
Old June 7th, 2004, 09:36 PM
JMorrell
external usenet poster
 
Posts: n/a
Default 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  
Old June 8th, 2004, 03:43 AM
Raghu Prakash
external usenet poster
 
Posts: n/a
Default 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  
Old June 8th, 2004, 02:01 PM
JMorrell
external usenet poster
 
Posts: n/a
Default 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  
Old June 9th, 2004, 08:44 AM
xuge120
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:24 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.