Patch for VB5 to open an Access 2000 Mdb 2

[jerjim]

In one of the threads, someone mentioned about a patch so that VB5 can work with Access 2000 databases, but he didn't mention where to download that patch. Usiing DAO objects 3.6 doesn't solve the problem.

Can anyone point me to the website where i can download a patch to Vb5 so that i can used a data control to open an Access 2000 database?

 

[hellovb]

Visit Microsoft site and search for 'Service Pack 4'.

Hellovb

 

[jerjim]

Service Pack 4 is for VB6, will it work for VB5.

 

[edderic]

you have just need the DAO360.dll to open Access 2000 with Visual Basic ,give me your e-mail adres and I send the .dll
Eric De Decker
vbg.be@vbgroup.nl

Licence And Copy Protection AxtiveX
Source CodeBook for the programmer

http://www.createsoftware2000.com

 

[hellovb]

Service Pack 4 now contains a value for the Connect property which allows DAO Data Control to open Access 2000 Databases.

 

[jerjim]

To ederic:

I have DAO360.DLL and my DAO statements are no problem.
It's the data control that comes with vb5 which won't work with an Access 2000 mdb.

To hellovb:
Will service pack 4 work for vb5? It was released for VB6.
I guess the best way to find out is to install it for vb5.

 

[bigfoot]

How about VB6? Does this work also?

Gary The door to life is never locked, but few have the knowledge to open it.

 

[hellovb]

Yes! service pack 4 will work with VB5. As I mentioned earlier, Service pack 4 contains a value which enables VB5 to open an Access2000 database. I believe changes were
made to the service pack.
I have tried it with both VB5 and VB6, successfully.

Hellovb

 

[Ekliptic]

jerjim,

Can you tell me how it worked out ???

Thanks

 

[hellovb]

To Jerjim and Tschock

Here's the resolution for VB5 - Access 2000 problem
It is applicable to VB5 and VB6

Install Visual Studio Service Pack 4.

For ADO (or the ADO Data Control), use the "Microsoft.Jet.OLEDB.4.0" provider.

For DAO, go to Project menu, and choose References to use the "Microsoft DAO 3.6 Object Library."

If you use the generic Data-Control, you need to open a DAO 3.6 recordset and then assign it to be the source of the Data Control as follows:

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&quot
Set Data1.Recordset = rs
End Sub

It should work!

Hellovb

 

[bigfoot]

Hi Hellovb, I use many of the generic Data-Controls in a very large project. Does that mean I have to rewrite the whole darn program assigning the recordset to them...

Thanks Microsoft!!!! >:-<

Why can't they do anything where the old stuff STILL WORKS!
I thought they were on our side, not trying to make more work for us.

Thanks, Gary X-)
The door to life is never locked, but few have the knowledge to open it.