Access and Visual Foxpro

[DL]

How can an access database be opened from a visual foxpro
session?

 

[Douglas J. Steele]

I think you'd be better off asking this in a Foxpro group. They start
microsoft.public.fox.vfp

 

[Albert D. Kallal]

Since VPF supports ADO...then yes, you can do this.

You will need to have JET installed on the pc in question..but the answer is
yes.

Since VPF was part of Visual Studio..then I assume just like VB6, the MDAC
stuff can be installed, and somewhere in the library JET is included.

 

[Cindy Winegarden]

In [email protected],

How can an access database be opened from a visual foxpro
session?

Hi DL,

You can use ODBC. You can create a VFP database and add a Connection to it
using the ODBC data source you have created. Then you can create a VFP
remote view to the table you want and then open the view. There are also
other ways such as SQL Pass-through. You can read more in the VFP Help on
Client/Server and SQL Pass-through.

Will you be reading the data only or are you planning to make
changes/updates to the data?