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
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?
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"
Summary: With my job I daily receive a .dbf file which has data from colums A to AI with the first row being the name tags e.g. ("Invoice Number" "Part Number" & etc.). Now, what I'm looking to do is somehow c...
Summary: If you want to open an existing database on your own then you're talking about reinventing the database engine, which is a fairly large job. First, you'll have to find out how the target database is s...
Summary: Hi. I'm currently doing my a-level computing project, and I'm having serious difficuly trying to build the database. I was wondering if there was anyway I could use SQL in delphi with a ms access data...