Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 To: abdul waheed
  Where is abdul waheed?
 Rahim Yar Kkhan
 abdul waheed
Subject: RE: Database Attach
Thread ID: 155361 Message ID: 155370 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Monday, December 31, 2007 11:22:18 AM         

> Hi Teacher I creat a DataBase into Access and want to attached V Foxpro 9 form I am very thank full to u
> RareZone

I am afraid that you cannot do that. To read data from an Access database into a Visual FoxPro form you will need to set up an ODBC Connection to the Access Database and then use either a Remote View, CursorAdapter or SQL PassThrough to retrieve data.

The easiest (though least flexible) way is to create a connection in your VFP Database - if you don't have one, just create a new database:
CREATE DATABASE access_viewer

Right click in the database designer and choose "connections" and then "new" to get the connection wizard. This will help you build the connection object (choose "new data source" and follow the steps).
Once you have saved your connection, right click in the designer and choose "new remote view" (again, there is a wizard to help you).

Once you have created your remote view, you can use it directly in a form exactly as if it were actually a VFP table.

Andy Kramek
Microsoft MVP (Visual FoxPro)
Tightline Computers Inc, Akron Ohio, USA


Database Attach Posted by abdul waheed @ 12/31/2007 8:21:56 AM
RE: Database Attach Posted by Andy Kramek @ 12/31/2007 11:22:18 AM
RE: Database Attach Posted by abdul waheed @ 1/5/2008 9:53:18 AM
RE: Database Attach Posted by Ken Murphy @ 1/5/2008 4:14:23 PM
RE: Database Attach Posted by Ken Murphy @ 1/1/2008 4:00:46 PM