MS-Access / VB

[Chakrapani]

Hi,

How to access MS-Access database, using VB application. Here, MS-Access
Db is not available on the local m/c. It is available on the LAN.

I want to know how to create the ODBC connection for MS-Access. Will MS-Access
does support RDO/ADO concept ??? If not how to over-come this situation ?

Thanks in advance,
chakri

[Arthur Wood]

Yes, MS Access can be accessed with ADO over a LAN, I do it all the time.


your code (using Access 97) will look something like this:

Dim conn as Connection
Dim rs as Recordset
Dim strSQL as String

Set conn = New Connection
conn.Provider = "Microsoft.Jet.OLEDB.3.51"
conn.Mode = adModeReadWrite

conn.Open "<your path to the database on the lan>"

strSQL = "Select * from <your table in database>"

set rs= New RecordSet
rs.Open strSQL,conn

<now you can use rs as you see fit>


this is very sketchy, and you would probably want to work with this in a
more scalable way, but this gives you the basic idea.

I would suggest you might find the book "Visual Basic 6 Business Objects"
by Rockford Lhotka to be informative.


Arthur Wood


"Chakrapani" <chakri_pani@india.dharma.com> wrote:
>
>Hi,
>
> How to access MS-Access database, using VB application. Here, MS-Access
>Db is not available on the local m/c. It is available on the LAN.
>
> I want to know how to create the ODBC connection for MS-Access. Will
MS-Access
>does support RDO/ADO concept ??? If not how to over-come this situation
?
>
> Thanks in advance,
> chakri