Run Time Error 3044

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vdraceil
    New Member
    • Jul 2007
    • 236

    Run Time Error 3044

    I'm working with VB6.0 and MS Access..The project runs perfectly in my computer..I ran the Package and Deployment Wizard to make a setup file for my project.I made it and when i ran the setup file in another computer,it shows an error that my database file could be found..
    i've used that dbase file in my project(almost in every form) with code,
    dim db as database
    set db=opendatabse( "D:\vino\532\db ase.mdb")

    I just want my project to run on every computer(with or without VB6.0).Help me out of this problem pls.
  • hariharanmca
    Top Contributor
    • Dec 2006
    • 1977

    #2
    Originally posted by vdraceil
    I'm working with VB6.0 and MS Access..The project runs perfectly in my computer..I ran the Package and Deployment Wizard to make a setup file for my project.I made it and when i ran the setup file in another computer,it shows an error that my database file could be found..
    i've used that dbase file in my project(almost in every form) with code,
    dim db as database
    set db=opendatabse( "D:\vino\532\db ase.mdb")

    I just want my project to run on every computer(with or without VB6.0).Help me out of this problem pls.

    You have to add your database in Package Wizard and the path in connection string should be

    App.Path & "\<Your Own Path>\DBFile.md b"

    and the instalation path should also in this path.

    Comment

    • vdraceil
      New Member
      • Jul 2007
      • 236

      #3
      Originally posted by hariharanmca
      You have to add your database in Package Wizard and the path in connection string should be

      App.Path & "\<Your Own Path>\DBFile.md b"

      and the instalation path should also in this path.
      Do you want me to change my code as
      Set db=opendatabase (App.path & "D:\vino\532\db ase.mdb")
      in every form ??
      If i add my database to the Package Wizard, wont the user be able to open it and edit it??
      This is the first time i'm ever using this wizard..pls explain it in steps...

      Comment

      • kinnu
        New Member
        • Nov 2006
        • 30

        #4
        Originally posted by vdraceil
        I'm working with VB6.0 and MS Access..The project runs perfectly in my computer..I ran the Package and Deployment Wizard to make a setup file for my project.I made it and when i ran the setup file in another computer,it shows an error that my database file could be found..
        i've used that dbase file in my project(almost in every form) with code,
        dim db as database
        set db=opendatabse( "D:\vino\532\db ase.mdb")

        I just want my project to run on every computer(with or without VB6.0).Help me out of this problem pls.
        =============== =============

        Is it showing error that database file could be found ??????
        or could not be found ?

        According to the error message the Application exe not able to find your database file and its is related to MS Access file. It think you are able to install the software (using package and deployement) in other computer fine but you are not able to use the software after installation. And it is giving the error message after you double click and run/open the software on other computer.

        A data base is a file that you have to attach in package and deployment setup.
        Provide the Location in Package & Deplyment that where you want to install/extract the MDB file from Cabinet file of P&D wizard.

        It is best/required to install/extract the MDB file to C:\ and your path rather than D:\ unless u know about the other computer.

        As far I know, the setup does not works if any person modifies the cabinet file or the files available in it.

        And a person can modify the MDB file after extraction and it depends on the requirement of the user.

        There are many more huge coding methods and options available in VB to avoid modifying the database or any other files.

        Comment

        • QVeen72
          Recognized Expert Top Contributor
          • Oct 2006
          • 1445

          #5
          Hi,

          P&D Wiz, does not copy the working folder's database and Report files, u have to do it manually. Whenevr u r writing big applications/projects, it is always a good practice that U keep a Centralized, Connection object (defined as Public in a .bas module). And also a Public Connection procedure, and call that proc in all the Forms, Better if u have one Public Conn object, Open that in MDI Form load and use it every where...

          REgards
          Veena

          Comment

          • Dököll
            Recognized Expert Top Contributor
            • Nov 2006
            • 2379

            #6
            Originally posted by vdraceil
            I'm working with VB6.0 and MS Access..The project runs perfectly in my computer..I ran the Package and Deployment Wizard to make a setup file for my project.I made it and when i ran the setup file in another computer,it shows an error that my database file could be found..
            i've used that dbase file in my project(almost in every form) with code,
            dim db as database
            set db=opendatabse( "D:\vino\532\db ase.mdb")

            I just want my project to run on every computer(with or without VB6.0).Help me out of this problem pls.
            Hiya, vdracei!

            Try writing it so VB looks for the path of your database on its own:

            [CODE=vb]
            Open App.Path + "\MyFile.tx t" For Output As #1
            Open App.Path + "\MyFile.tx t" For Append As #1
            Open App.Path + "\MyFile.tx t" For Input As #1
            [/CODE]

            Something in that kind of a line. Modify to reflect mdb instead of txt. Give that a whirl, see what you have.

            Good luck with the project!

            Comment

            • vdraceil
              New Member
              • Jul 2007
              • 236

              #7
              Originally posted by kinnu
              =============== =============

              Is it showing error that database file could be found ??????
              or could not be found ?

              According to the error message the Application exe not able to find your database file and its is related to MS Access file. It think you are able to install the software (using package and deployement) in other computer fine but you are not able to use the software after installation. And it is giving the error message after you double click and run/open the software on other computer.

              A data base is a file that you have to attach in package and deployment setup.
              Provide the Location in Package & Deplyment that where you want to install/extract the MDB file from Cabinet file of P&D wizard.

              It is best/required to install/extract the MDB file to C:\ and your path rather than D:\ unless u know about the other computer.

              As far I know, the setup does not works if any person modifies the cabinet file or the files available in it.

              And a person can modify the MDB file after extraction and it depends on the requirement of the user.

              There are many more huge coding methods and options available in VB to avoid modifying the database or any other files.

              How do i protect my database from within vb? i want to prevent others from editing it..help me pls,my project is hanging on for a long time..

              Comment

              Working...