General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Refresh a VFP ODBC connection in MS Access
Refresh a VFP ODBC connection in MS Access
I have setup an ODBC connection to a VFP Database
in MS Access. It is accessed thru a Win '98 pier-to-pier
network. We use MS Access to run queries. However,
time has gone by since the "connection" was made and we
find that the retrieved data is "out-of-date".
When we create a new MS Access MDB and "link" in the
ODBC FoxPro Tables, the MS Access queries become current.
Is there a way to "refresh" the connection without having
to re-create the connection?
P.S. We are "linking" and not "importing".
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only