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" <email@example.com> 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,
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL