By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,646 Members | 2,105 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,646 IT Pros & Developers. It's quick & easy.

VB 6.0 and Access Database

P: 8
hi,

I am trying to connect Access database to a VB 6.0 Form. When i click on 'Recordsource property' a message box says "unrecognized database format 'C:\ Documents and Settings\somebody's name\Desktop\trial\db1.mdb' and when i click on help, it says "The MSDN collection does not exist. Please, install MSDN". The database, 'db1' and the VB forms also are
found in the folder 'trial' on the desktop. What should i do?

Please, email me to tell me where should i look for the relpy.
Thanks
Nov 28 '06 #1
Share this Question
Share on Google+
3 Replies


sashi
Expert 100+
P: 1,754
hi,

I am trying to connect Access database to a VB 6.0 Form. When i click on 'Recordsource property' a message box says "unrecognized database format 'C:\ Documents and Settings\somebody's name\Desktop\trial\db1.mdb' and when i click on help, it says "The MSDN collection does not exist. Please, install MSDN". The database, 'db1' and the VB forms also are
found in the folder 'trial' on the desktop. What should i do?

Please, email me to tell me where should i look for the relpy.
Thanks
Hi there,

Please upgrade you MDAC, the latest is version 2.8. Place the access database outside desktop area. Kindly follow the below attached link to download MDAC 2.8, hope it helps. Good luck & Take care.

MDAC 2.8
Nov 28 '06 #2

P: 3
hi,

I am trying to connect Access database to a VB 6.0 Form. When i click on 'Recordsource property' a message box says "unrecognized database format 'C:\ Documents and Settings\somebody's name\Desktop\trial\db1.mdb' and when i click on help, it says "The MSDN collection does not exist. Please, install MSDN". The database, 'db1' and the VB forms also are
found in the folder 'trial' on the desktop. What should i do?

Please, email me to tell me where should i look for the relpy.
Thanks

Hi,
i think, in ur system vb 6.0 and ms-access 2000, then u r connecting through "data1" control. if those are true, then use "adodc1" control. hope, it will solve u r problem.

bye
Nov 29 '06 #3

sashi
Expert 100+
P: 1,754
Hi,
i think, in ur system vb 6.0 and ms-access 2000, then u r connecting through "data1" control. if those are true, then use "adodc1" control. hope, it will solve u r problem.

bye
Hi there,

I doubt that would be the solution, reason why, the error "unrecognized database format" is a common error message when your trying to open access 97 files. In order ro fix the error MDAC need to be updated. Anyway, hope you solution work. Take care.
Nov 29 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.