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!
Printable View
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!
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
Hi,
Change DAO Library 3.6 to 3.0 or 3.5 ok