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

DoCmd Without Access-2003

P: 41
I have designed software with VB6.0 as frontEnd & access-2003 as backend. For running action queries & for importing text files to my database i am using DoCmd object for which i have add reference to Miscrosoft Access 11.0 object library. In my PC it works fine as i have installed Access 2003 in my PC but in other PC's where Access -2003 is not installed it is giving error "Can not create ActiveX object" and other errors also. It works fine if i install Access-2003 to these PC's. How can i get rid of this problem without installing Access-2003 in each PC's. I have created setup with Visual Studio Installer.
Thanks
May 18 '08 #1
Share this Question
Share on Google+
4 Replies


lotus18
100+
P: 866
I have designed software with VB6.0 as frontEnd & access-2003 as backend. For running action queries & for importing text files to my database i am using DoCmd object for which i have add reference to Miscrosoft Access 11.0 object library. In my PC it works fine as i have installed Access 2003 in my PC but in other PC's where Access -2003 is not installed it is giving error "Can not create ActiveX object" and other errors also. It works fine if i install Access-2003 to these PC's. How can i get rid of this problem without installing Access-2003 in each PC's. I have created setup with Visual Studio Installer.
Thanks
Hi

You have to include Microsoft Access 11.0 object library in your package.

Rey Sean
May 18 '08 #2

Dököll
Expert 100+
P: 2,364
Listen to Rey Sean, VB must have components/references that are vital to the whole application. Furthermore, I've had this problem and sometimes I found it is the version of Access, from 2000 to 2003 as one example, that seems to be the problem; Active X controls therefore do not work... might want to also keep that in mind.

Sorry for your troubles, must be annoying...

Dököll
May 20 '08 #3

P: 41
I have already included reference to Access 11.0 library in package even then problem arises.
May 20 '08 #4

jeffstl
Expert 100+
P: 432
I have already included reference to Access 11.0 library in package even then problem arises.
OK I don't mean to ask questions that you may think as obvious but sometimes they sneak by.

You say you included the reference to the library in your project. Did you re-compile and re-create the installation files after this inclusion? Then re-distribute and have your users re-install?

The compiled .exe should work on every PC its put on if it works on one PC. Especially if the installation was done properly and all the files have been copied over. If the .mdb file is part of the installation package and they don't have Access installed, that I'm not sure of though
May 20 '08 #5

Post your reply

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