Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access to MS access databas
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00363561
Message ID:
00363568
Views:
22
>I'm currently developing a VFP app which needs to access data from a MS Access databse (A .MDB file, but I think this is a datbase with a number of tables in it)
>
>My questions are :
>
>1. Can I pull data from these tables from within my VFP app
>2. Is it easy to do this (hopefully just do a Sele 0, Use Myaccess)

Yes, with remote views and ODBC. Create an ODBC DSN to the Access MDB. Then in VFP, create a connection using that DSN. Then create remote views to any of the tables in the MDB using that connection.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform