Access and Visual Foxpro

  • Thread starter Thread starter DL
  • Start date Start date
I think you'd be better off asking this in a Foxpro group. They start
microsoft.public.fox.vfp
 
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.
 
In [email protected],
DL said:
How can an access database be opened from a visual foxpro
session?
Click to expand...

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot open dbf file created in Visual Foxpro 7 or 9 in EXCEL 2010 0
table structure 1
I need to start a vb.net 2008 program via Task Scheduler 2
Help changing FoxPro to VB Code 1
Visual FoxPro 6.0 2
Reading Visual foxpro table in VB 6.0 2
How to export foxpro db to access mdb 7
How can i import data from a Visual FoxPro 6.0 to an Access 2003 D 5

Back
Top