linking data to msaccess 1

[danab]

Is there a way to link a foxpro table to an msaccess table??<br>
I don't want to import data but to link the data continuasly.<br>
Thanks.<br>
Danab.

 

[ISY]

Yes. You simply have to use an ODBC connection. There is an ODBC driver to MsAccess table available with Win95/98/NT. Read about ODBC connections in the Fox help; it's quite simple actually.

 

[SCRyan]

Can this be done if the tables are linked to a container(dbc)? I want to use access as a report and fiel generator at remote locations because I have licensed ACCESS software in place at the remote sites along with a purchased software package that uses Foxpro as it's engine. I figure I would have to purchase additional licensing for FOxpro to use it at all the reomte sites.

 

[Orion7]

Look into remote views for FoxPro. Therein lies your answer. Also these can be requied to show new table contents. Combining OBDC with remote views will allow you to integrate to almost any database.