DoCmd Without Access-2003

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Neelesh2007
    New Member
    • Oct 2007
    • 41
    #1

    DoCmd Without Access-2003

    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
    Tags: None
    • lotus18
      Contributor
      • Nov 2007
      • 865
      #2
      Originally posted by Neelesh2007
      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

        Comment

        • Dököll
          Recognized Expert Top Contributor
          • Nov 2006
          • 2379
          #3
          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

            Comment

            • Neelesh2007
              New Member
              • Oct 2007
              • 41
              #4
              I have already included reference to Access 11.0 library in package even then problem arises.

                Comment

                • jeffstl
                  Recognized Expert Contributor
                  • Feb 2008
                  • 432
                  #5
                  Originally posted by Neelesh2007
                  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

                    Comment

                    Previous template Next
                    Working...