Unable to use access2000 in VB6.0
Help me please!!!
I am using Visual Basic6. and I want to use Access2000 as a back end. But while using Data Control object it says "Unrecognized Database format"
Waiting for soon reply.....
Web Development
Help me please!!!
I am using Visual Basic6. and I want to use Access2000 as a back end. But while using Data Control object it says "Unrecognized Database format"
Waiting for soon reply.....
by donq
No Problem!
1. Open theActiveX Controls Window under the Tools menu item and add whatever VB6 "Microsoft" controls your local machine is missing from the libraries. You may need the Access CD???
by naresh809
by peyison
Try installing the latest version of MDAC (Misrosoft Data Access Components).
You can find it at:
Here's the link to the actual download page:
http://www.microsoft.com/data/download_25SP1.htm
(remove any spaces in the URLs)
The file you want to download is MDAC_TYP.EXE. If you distribute VB apps, you should copy this over your existing verison of MDAC_TYP.EXE (do a find to get the location).
Hope this helps.
by naresh809
Sir,
As per your instruction in had installed MDAC_TYP.EXE but still i am unable to use access2000 database in vb6, please help me if you have any other solution.
thanks
Sounds like you have an earlier version of DAO/ADO referenced. Go to Project|References and make sure you are using the correct version.
Also when initialising variables make sure you prefix the objects with the data access type. e.g.
Dim db as DAO.database
Hope this helps
by naresh809
by peyison
Try installing the latest version of Jet (4.0). It used to be that Jet was installed with MDAC, but it is not anymore. You can download it at (remove spaces, if any):
http://www.microsoft.com/data/download_Jet4SP3.htm
Also, you might think about moving to ADO instead of DAO.
Hope this helps.
by naresh809
by naresh809
This discussion is closed to new replies.
Sort by Trending