944,179 Members | Top Members by Rank

Ad:
Nov 11th, 2009
0

VB6 Run-time error '53': FIle not not found

Expand Post »
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.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Sorb3t3ro is offline Offline
14 posts
since Nov 2009
Nov 11th, 2009
0
Re: VB6 Run-time error '53': FIle not not found
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
Reputation Points: 156
Solved Threads: 296
Posting Virtuoso
vb5prgrmr is offline Offline
1,670 posts
since Mar 2009
Nov 11th, 2009
0
Re: VB6 Run-time error '53': FIle not not found
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?
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Sorb3t3ro is offline Offline
14 posts
since Nov 2009
Nov 11th, 2009
0
Re: VB6 Run-time error '53': FIle not not found
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
Reputation Points: 156
Solved Threads: 296
Posting Virtuoso
vb5prgrmr is offline Offline
1,670 posts
since Mar 2009
Nov 12th, 2009
0
Re: VB6 Run-time error '53': FIle not not found
What kind of connection are you using? DAO or ADO ?

How do you access the database...???
In ADO, an exapmle is:
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
  1. Dim cn As ADODB.Connection
  2. Dim rs As ADODB.Recordset
  3.  
  4. Set cn = New ADODB.Connection
  5. cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
  6. "Data Source= " & App.Path & "\database.mdb;Persist Security Info=False;Jet OLEDB:Database Password=ElE;"
  7. 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
Last edited by akhileshbc; Nov 12th, 2009 at 4:30 am.
Reputation Points: 10
Solved Threads: 5
Newbie Poster
akhileshbc is offline Offline
14 posts
since Nov 2009
Nov 16th, 2009
0
Re: VB6 Run-time error '53': FIle not not found
ok. what location you give in your project. is it same as what your said?
Reputation Points: 14
Solved Threads: 78
Practically a Posting Shark
abu taher is offline Offline
835 posts
since Jul 2008
Nov 16th, 2009
0
Re: VB6 Run-time error '53': FIle not not found
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.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Sorb3t3ro is offline Offline
14 posts
since Nov 2009
Nov 16th, 2009
0
Re: VB6 Run-time error '53': FIle not not found
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.
Reputation Points: 329
Solved Threads: 347
Senior Poster
AndreRet is offline Offline
3,700 posts
since Jan 2008
Nov 16th, 2009
0
Re: VB6 Run-time error '53': FIle not not found
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
Reputation Points: 156
Solved Threads: 296
Posting Virtuoso
vb5prgrmr is offline Offline
1,670 posts
since Mar 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: VBA excel - Dynamicly loaded Ribbons?
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: maximise form with controls





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC