Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 To: Bong Valdez
  Where is Bong Valdez?
 Manila
 Philippines
 Bong Valdez
 Tags
Subject: RE: Microsoft Access MDB "Read in, or Convert?"
Thread ID: 33462 Message ID: 33611 # Views: 2 # Ratings: 0
Version: Visual FoxPro 6 Category: Active X Controls & OLE Automation
Date: Sunday, November 30, 2003 11:38:26 AM         
   


> What I want is to read table from MDB, there will be no update to MDB.
> Any suggestion?
>
>
> Bong C Valdez
>
> > > I need to read table in MDB file from my VFP 6.0 App. I have searched the archive but I still don't know how to do it.
> > > Is there anyone can help me?
> > >
> > > 1. Is it true I need to use ODBC to connect Access MDB? How?
> > > 2. What is the code to read records from table in MDB?
> > > 3. After that, how can I put it in my app?
> > >
> > > Sorry, I have no experience using ODBC and Access MDB.
> > >
> > > Many thanks.
> > > Bong C Valdez
> >
> >
> > Hi,
> > Are you trying to keep the MS Access tables and just work with them in VFP?
> > or
> > Port them into VFP?
> >
> > Pete from the Great White North. (Only in Canada, ay.) Over and Out ...


Hi,
Proabably the easiest method is to add an ODBC connection at the workstation targeting the
Access.mdb.
In VFP open your database and add a connection to this ODBC connection. Then use Remote
Views to access any table in the MDB that you want. This will load the Access table into a
VFP cursor. Depending upon your options in the remote view you can allow, or deny update
capabilities to the Access table.

Pete from the Great White North. (Only in Canada, ay.) Over and Out ...


ENTIRE THREAD

Microsoft Access MDB Posted by Bong Valdez @ 11/27/2003 1:50:26 AM
RE: Microsoft Access MDB Posted by Eric den Doop @ 11/27/2003 7:37:26 AM
Sorry Eric, can you give me more information? Posted by Bong Valdez @ 11/27/2003 1:34:08 PM
RE: Sorry Eric, can you give me more information? Posted by Eric den Doop @ 11/27/2003 2:10:40 PM
Microsoft Access MDB "Read in, or Convert?" Posted by Pete Sass @ 11/28/2003 9:58:27 PM
RE: Microsoft Access MDB "Read in, or Convert?" Posted by Bong Valdez @ 11/29/2003 1:02:31 AM
RE: Microsoft Access MDB "Read in, or Convert?" Posted by Pete Sass @ 11/30/2003 11:38:26 AM