Connect access2000 to vb6
I am trying to connect an access 2000 database to vb6. What is the easiest
way to do it.
Thank you in advance
Re: Connect access2000 to vb6
There are number of ways to connect to the Access
Eg : Through DataControl ,Through an odject (Database object),ODBC ...etc.
HOw would you like to connect.
If you want to connect through a control then place the conrtol on the form
and set its database properties according to your requirements.you nee to
set (i)Database Name (ii)RecordSource
If you want to connect through a object the nhere is the code:
Dim wrkJet As Workspace
Dim dbsNorthwind As Database
Dim dbsPubs As Database
Dim dbsPubs2 As Database
Dim dbsLoop As Database
Dim prpLoop As Property
' Create Microsoft Jet Workspace object.
Set wrkJet = CreateWorkspace("", "admin", "", dbUseJet)
' Open Database object from saved Microsoft Jet database
' for exclusive use.
Set dbsNorthwind = wrkJet.OpenDatabase("Northwind.mdb", _
Hope This will serve your purpose.
All the Best
"Jason Douglas" <firstname.lastname@example.org> wrote:
>I am trying to connect an access 2000 database to vb6. What is the easiest
>way to do it.
>Thank you 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