Computing.Net > Forums > Programming > how to package Access database correctly

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

how to package Access database correctly

Reply to Message Icon

Name: George
Date: May 30, 2002 at 13:02:46 Pacific
Comment:

Hi, I have a question regarding the Package and Deployment Wizard in VB 6.
My program deals with database access. It needs a Microsoft Access
database file that I have created. I did include that file during
the "Included Files Dialog" in the package wizard. But after I setup and
install the program, I was unable to use the program. I got an error
message that says database provider not found. But my access database file
is there with the package.

What do I need to do to package the MS Access correctly with the rest of
my program?

Thanks

George



Sponsored Link
Ads by Google

Response Number 1
Name: CyberDuck
Date: May 30, 2002 at 13:52:18 Pacific
Reply:

Do you have the necessary MDAC version for your access database?


0

Response Number 2
Name: George
Date: May 30, 2002 at 15:24:44 Pacific
Reply:

What is MDAC?
My database program works before I packaged it using the package and deployment wizard. Do I need that MDAC after I package it??? What should I do after I download the MDAC? Where should I copy the file to?

Thanks

George


0

Response Number 3
Name: CyberDuck
Date: May 30, 2002 at 20:59:51 Pacific
Reply:

George,

Are you testing the package deployment on a computer other than the one you did your development on? If you are, MDAC (Microsoft Data Access Components) may be required to allow your VB program to use the DB engine needed to access your DB. I believe it is the Jet DB Engine. Someone post a correction if this is incorrect. The latest MDAC version I have used is V. 2.5. If you are testing on the same machine, I would look at my ODBC sources and see if you have a DB driver installed for access.

HTH.


0

Response Number 4
Name: George
Date: May 31, 2002 at 08:06:33 Pacific
Reply:

Yes, I am testing the package on different computers and it is not working. I am using Access 97. Someone also had mentioned to me about the MDAC. But I also found something else in my VB book in the section of package and deployment wizard. It says:
"if you are accessing an Access (Jet) database, you may need to custom add a system.mdw or readme.txt file"

Anyone know anything about this?

Thanks

George


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: how to package Access database correctly

Help on how to create database www.computing.net/answers/programming/help-on-how-to-create-database/9167.html

How to create & save Database in C www.computing.net/answers/programming/how-to-create-amp-save-database-in-c/10418.html

Access databases with Delphi www.computing.net/answers/programming/access-databases-with-delphi/15225.html