MS-Access / VB
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,
Re: MS-Access / VB
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
<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.
"Chakrapani" <firstname.lastname@example.org> wrote:
> 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
>does support RDO/ADO concept ??? If not how to over-come this situation
> Thanks in advance,
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center