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. :)
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?
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.
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;"
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
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.
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...