Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connecting to an MS Access Database
Message
From
20/06/2003 00:49:51
Gerry Schmitz
GHS Automation Inc.
Calgary, Alberta, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00802042
Message ID:
00802063
Views:
30
>My question is, what will be my best way to connect to the MS Access Database? This is my first attempts at Remote Views and Connections. Is ODBC by only and best choice? Is COMM or DCOM a choice for me?

You can use Automation (i.e. COM) to connect to MS Access Databases (.MDBs) via DAO or ADO (the 2 commonly used object models).

Which is "best" (COM, remote views and ODBC) is maybe more a matter of personal preference.

I prefer COM because it is object oriented, and since VB generally uses DAO or ADO, it's easier to port Access samples (which are many) from VB to VFP ... I also think COM (in this case) is more fun.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform