Access 2000 and VB6 
Author Message
 Access 2000 and VB6

Is there an update so that I can use an access 2000 database with VB6?
If yes, where?
Thank you,

Amine



Thu, 19 Dec 2002 03:00:00 GMT  
 Access 2000 and VB6
You have to hook up with an Access2000 database at run-time, you cannot set
it with the properties window during design-mode.
First, make sure that in references you have a reference to the Microsoft
DAO 3.6 Object Library.

The following snippet is from the MS Knowledge base:

Option Explicit

Private daoDB36 As Database
Private rs As DAO.Recordset
Dim sPath As String

Private Sub Form_Load()

sPath = "C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb"
Set daoDB36 = DBEngine(0).OpenDatabase(sPath)
Set rs = daoDB36.OpenRecordset("Customers")
Set Data1.Recordset = rs

<Do your stuff here>

End Sub

--
Ed Adamthwaite
Remove SpamMeNot to reply

Quote:
> Is there an update so that I can use an access 2000 database with VB6?
> If yes, where?
> Thank you,

> Amine



Thu, 19 Dec 2002 03:00:00 GMT  
 Access 2000 and VB6
Hi,

You can also try the newly released Service Patch 4 for Visual Studio...

Hoping it may help,
Vanderghast, Access MVP.


Quote:
> You have to hook up with an Access2000 database at run-time, you cannot
set
> it with the properties window during design-mode.
> First, make sure that in references you have a reference to the Microsoft
> DAO 3.6 Object Library.

> The following snippet is from the MS Knowledge base:

> Option Explicit

> Private daoDB36 As Database
> Private rs As DAO.Recordset
> Dim sPath As String

> Private Sub Form_Load()

> sPath = "C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb"
> Set daoDB36 = DBEngine(0).OpenDatabase(sPath)
> Set rs = daoDB36.OpenRecordset("Customers")
> Set Data1.Recordset = rs

> <Do your stuff here>

> End Sub

> --
> Ed Adamthwaite
> Remove SpamMeNot to reply


> > Is there an update so that I can use an access 2000 database with VB6?
> > If yes, where?
> > Thank you,

> > Amine



Fri, 20 Dec 2002 03:00:00 GMT  
 Access 2000 and VB6
Thanks everyone...


Quote:
> Hi,

> You can also try the newly released Service Patch 4 for Visual Studio...

> Hoping it may help,
> Vanderghast, Access MVP.



> > You have to hook up with an Access2000 database at run-time, you cannot
> set
> > it with the properties window during design-mode.
> > First, make sure that in references you have a reference to the
Microsoft
> > DAO 3.6 Object Library.

> > The following snippet is from the MS Knowledge base:

> > Option Explicit

> > Private daoDB36 As Database
> > Private rs As DAO.Recordset
> > Dim sPath As String

> > Private Sub Form_Load()

> > sPath = "C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb"
> > Set daoDB36 = DBEngine(0).OpenDatabase(sPath)
> > Set rs = daoDB36.OpenRecordset("Customers")
> > Set Data1.Recordset = rs

> > <Do your stuff here>

> > End Sub

> > --
> > Ed Adamthwaite
> > Remove SpamMeNot to reply


> > > Is there an update so that I can use an access 2000 database with VB6?
> > > If yes, where?
> > > Thank you,

> > > Amine



Sat, 21 Dec 2002 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. access 2000 ET vb6

2. Access 2000 with VB6.0 - Stopped working...why?

3. Access 2000 and VB6

4. access 2000 to vb6

5. Columns in Access 2000 via VB6

6. Problem with ACCESS 2000 and VB6

7. Access 2000 and VB6

8. access 2000 in VB6 ??

9. Performance issue - Access 2000 using VB6 and ADO 2.1 with SQL

10. LIKE query gives different results in Access 2000 and VB6 SP5

11. Access 2000 and VB6

12. Access 2000 in VB6

 

 
Powered by phpBB® Forum Software