Access XP (2002) and visual basic 6

[robman70]

sorry, the search is down right now so i couldnt just look this up, has anyone had any problems using MS Access from MS Office XP and visual basic 6, every time i try to select the RecordSource i get a msg saying 'unrecognized database format "C:\testdb.mdb"', ive done this a million times, but never with access xp, does anyone know of any known issues?
any help appreciated

 

[Learning123]

Hi Rodman,
From what I've heard Access XP Databases was actually geared up for Visual Studios .Net. So it won't be compatible with Visual Basic 6 and below. One Solution is to simply convert your DB to a 97 format with the DataBase Utilities. Hope this help.

Mark She's a Lithium Flower

 

[sunaj]

Hi,

You need to use ADO 2.6+ to be able to handle Access 2002 databases.
You can download MDAC (which includes ADO) from

http://www.microsoft.com/data/download.htm

Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[robman70]

actually, shortly after posting i decided to see about doin' some googlin'...i didnt know there were service packs for visual studio, i installed sp5 and all my problems were fixed

thanks for all the help

its funny, almost anytime ive posted, at least one person responding has called me roDman hehe