Member Avatar

Hi! I have a VB6 project and I used ms access as my database(Database.mdb), I packed my project including the database, I already install it on my PC, but when I use or run my newly installed VB6 project and type the username and password I got this error: Run-time error '53': File not found. Can somebody explain why I got this error? Please I need help. Thanks. :)

Member Avatar

Where did you tell your setup package to install your database? Because I believe the path you used to point to your database is incorrect and hence the error you are recieveing...

Good Luck

Member Avatar

I put it on C:\Program Files\Microsoft Visual Studio\VB98\CSCI15\Package\Support. I aslo include the Setup.ini file setting the path to C:\Program Files\Microsoft Visual Studio\VB98\CSCI15\Package\Support. But still have have the same error. This is my first time to pack a VB6 project with a database. I think there's something wrong with the packaging process. Any help?

Member Avatar

Are you using the PDW? (Package and Deployment Wizard) If so, when you are walking through the steps, there is a screen that allows you to add files (Files are not added automatically when you put them in the support directory, you have to add them.). Use this screen to add the database and to specify where it is to be installed.

Good Luck

Member Avatar

What kind of connection are you using? DAO or ADO ?

How do you access the database...???
In ADO, an exapmle is:

Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset

Set cn = New ADODB.Connection
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
      "Data Source= " & App.Path & "\database.mdb;Persist Security Info=False;Jet OLEDB:Database Password=ElE;"
    cn.Open

Look at the 6 line of code...
If the database is residing in the same folder(ie. application folder), then, for example if you have installed in "C:\mysoft" folder,then
App.path & "\database.mdb" gives C:\mysoft\database.mdb

Edited by akhileshbc: n/a
Member Avatar

ok. what location you give in your project. is it same as what your said?

Member Avatar

I put the support folder inside the package folder here is the complete path: C:\Program Files\Microsoft Visual Studio\VB98\CSCI15\Package\Support. And the database is inside the support folder.

Member Avatar

It seems that your connection is looking for the database in the same place as to when you were developing your app. Go make sure that it is still in the same folder on the SAME pc you developed on as to where you have installed onto. In other words, if you installed onto a different pc, the app is looking for a database in a folder the same as to where you saved it on your own pc.
If the installed pc and the development pc is the same, your app. is looking for another file not saved in the correct folder. Check all your files that was added to the setup to your actual developed app.

Hope this help.

Member Avatar

To begin with, let me reiterate that just because you put a file in the support folder does not mean it will be included with your setup package! You have to manually add the file when creating your setup package and when you do so you have to specify exactly where you want it to be installed! Then if you have hard coded your path to where this file is located in your code and the file is not installed in that exact same place...

Good Luck