General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only