Click to See Complete Forum and Search --> : Access 2000 and VB6


August 21st, 1999, 12:30 AM
Sorry if this has been answered before but can VB6 w/ SP3 handle Access 2000 database files? I get an error saying unrecognized database format.

Thanks!

Vlad Chapranov
August 21st, 1999, 07:06 PM
You cannot use Data Control directly with new format, but you can create DAO (using DAO360.dll)or ADO recordset. If you must use Data Control for some reason (I had a such situation) you need create DAO recordset and assign it as recordset to Data Control:
Dim db as Database
Dim rsMyRecordset as Recordset
Set db = OpenDatabase("Name")
Set rsMyRecordset = db.OpenRecordset("SELECT * FROM ...", dbOpenDynaset)
Set Data1.Recordset = rsMyRecordset
HTH
Vlad Chapranov, MCP

murthynerella
September 20th, 1999, 05:48 AM
Hi,
Change DAO Library 3.6 to 3.0 or 3.5 ok