|
| 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
May 18th, 2010, 04:35 PM
posted to microsoft.public.access
|
|||
|
|||
Refresh ODBC link
I have a link set up to pull information from our system directly to an
Access table. Our systems department has added a couple of new fields to the table but it doesn't automatically update my Access table. Is there a way to refresh the table to get these new fields, or do I have to set up a new table? Thanks. 
|
|
#2
May 18th, 2010, 04:41 PM
posted to microsoft.public.access
|
|||
|
|||
|
Refresh ODBC link
Go to the linked table manager (Tools/Database Utilities), open and select
your table, then refresh the link. Milton Purdy ACCESS State of Arkansas "nitengale" wrote: I have a link set up to pull information from our system directly to an Access table. Our systems department has added a couple of new fields to the table but it doesn't automatically update my Access table. Is there a way to refresh the table to get these new fields, or do I have to set up a new table? Thanks.
|
|
#3
May 18th, 2010, 05:00 PM
posted to microsoft.public.access
|
|||
|
|||
|
Refresh ODBC link
Thank you - I knew it was something simple and I was just having a moment.
"golfinray" wrote: Go to the linked table manager (Tools/Database Utilities), open and select your table, then refresh the link. Milton Purdy ACCESS State of Arkansas "nitengale" wrote: I have a link set up to pull information from our system directly to an Access table. Our systems department has added a couple of new fields to the table but it doesn't automatically update my Access table. Is there a way to refresh the table to get these new fields, or do I have to set up a new table? Thanks.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
