Access with Visual Foxpro 6.0

[ndello]

I have a database in Access97 that links to Visual Foxpro6.0 tables.
I just upgraded to Access 2000 and the links are lost. If I try to reconnect the links, I cannot see Visual Foxpro as a table selection.

Any ideas?

Thanks
Neil

 

[dtaylor]

you will need to re-establish the fox pro table under the ado (2000) environment.

Dan

 

[ndello]

Dan, can you tell me more on the ado?

 

[dtaylor]

Hi Nedello,
to link the fox pro table you will need to create an ODBC connection to the database and then link ODBC connection. You may already have it there. Select 'Link' and then ODBC, see if the connection is there, if it is select it.

If you need to create the connection and do not know how - do a search on MSDN knowledge base.

http://msdn.microsoft.com/default.asp

lots of good info on all of ms products.

another way I have done this in the past is to pull the data into excel via 'Get Exteranl Data' and then link the excel - not as elegant and more time comsuming but it works.

Dan

 

[ndello]

thank you