473,573 Members | 4,147 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Package and Deployment Wizard Question

Good Afternoon,

I need to distribute an application which includes the run time files for
Access 2002. I do have the Office XP Developer CD’s. The application itself
is written in VB 6 with an Access back-end. I have created a number of
reports in Access and I am starting them from the Visual Basic Front End.
However, I have a number of users who do not have a copy of Access which
means they will obviously need the run time files.

From what I understand the way to get the runtime files is to use the
package and deployment wizard available as an Access add-in. OK. Great. And
where is that little sucker? I do have the Package and Deployment Wizard for
Visual Basic but that has no intent of taking an mdb or mde database as the
primary file. In fact, it refuses to work with anything but a VB project
file; so obviously I need the one from Access. Do I have to reload the
Access files from the Developer CD’s (Access install part) or from the
Office Developer’s CD; or, better yet; Is there somewhere on one of those
CD’s a folder having all the Access runtime files.

Any suggestions, hints, advice is more than welcome and much appreciated.
Nov 13 '05 #1
4 3809


I am not sure about this, so I'll state it as a question:
Are you legally able to distribute the Access files?

In any case, I am not sure why you need for your users
to have Access. If I understood correctly, you have a VB6
app that uses an access mdb file. Is that correct? Is that the
extent that you are using Access?

When you build an app that uses the mdb file, the Package
and Deployment Wizard (setup wiz) will most likely detect
which support files you need and include them inthe setup
package.

The beauty (or ugliness) of using mdb file within VB is that
the target pcs where your solution is deployed do not need
to have Access installed.

In cases where you want your users to manipulate the db
outside of your app, then it is when they need Access (or
some other equivalent application). In this case, the only
solution is to install Access on each of the target PCs that
need it. I usually do not recommend modifying or manipulating
data outside of its front end, as it becomes too dangerous,
but if ya have to, ya have to.

Good luck.
Saga

<Th********@NOS PAM.earthlink.n et> wrote in message
news:Ia******** **********@news read1.news.pas. earthlink.net.. .
Good Afternoon,

I need to distribute an application which includes the run time files
for
Access 2002. I do have the Office XP Developer CD's. The application
itself
is written in VB 6 with an Access back-end. I have created a number of
reports in Access and I am starting them from the Visual Basic Front
End.
However, I have a number of users who do not have a copy of Access
which
means they will obviously need the run time files.

From what I understand the way to get the runtime files is to use the
package and deployment wizard available as an Access add-in. OK.
Great. And
where is that little sucker? I do have the Package and Deployment
Wizard for
Visual Basic but that has no intent of taking an mdb or mde database
as the
primary file. In fact, it refuses to work with anything but a VB
project
file; so obviously I need the one from Access. Do I have to reload the
Access files from the Developer CD's (Access install part) or from the
Office Developer's CD; or, better yet; Is there somewhere on one of
those
CD's a folder having all the Access runtime files.

Any suggestions, hints, advice is more than welcome and much
appreciated.

Nov 13 '05 #2
If you've installed the Developer Files, the P&D wizard should show up on
the same menu as the compiler where you create the MDE file. Be aware, there
are two major issues --

1) It is one MONSTER installation - over 110 MB last time I tried it.

2) It wreaks havoc for users who DO have Access installed, particularly if
they have a different version.


<Th********@NOS PAM.earthlink.n et> wrote in message
news:Ia******** **********@news read1.news.pas. earthlink.net.. .
Good Afternoon,

I need to distribute an application which includes the run time files for
Access 2002. I do have the Office XP Developer CD's. The application itself is written in VB 6 with an Access back-end. I have created a number of
reports in Access and I am starting them from the Visual Basic Front End.
However, I have a number of users who do not have a copy of Access which
means they will obviously need the run time files.

From what I understand the way to get the runtime files is to use the
package and deployment wizard available as an Access add-in. OK. Great. And where is that little sucker? I do have the Package and Deployment Wizard for Visual Basic but that has no intent of taking an mdb or mde database as the primary file. In fact, it refuses to work with anything but a VB project
file; so obviously I need the one from Access. Do I have to reload the
Access files from the Developer CD's (Access install part) or from the
Office Developer's CD; or, better yet; Is there somewhere on one of those
CD's a folder having all the Access runtime files.

Any suggestions, hints, advice is more than welcome and much appreciated.

Nov 13 '05 #3

"Saga" <an******@somew here.com> wrote in message
news:uq******** *****@TK2MSFTNG P11.phx.gbl...


I am not sure about this, so I'll state it as a question:
Are you legally able to distribute the Access files?
If you have Office Developer, yes. It creates a compiled database
application (mde rather than mdb), so users can (in theory) run the Access
app without being able to use Access itself.

In any case, I am not sure why you need for your users
to have Access. If I understood correctly, you have a VB6
app that uses an access mdb file. Is that correct? Is that the
extent that you are using Access?
As the OP said, there are some Access reports fired from the VB app. Not a
method many people would recommend, but technically feasible.

Nov 13 '05 #4


On 1-Nov-2004, "Jezebel" <dw*****@heaven .com.kr> wrote:
If you've installed the Developer Files, the P&D wizard should show up on
the same menu as the compiler where you create the MDE file. Be aware,
there
are two major issues --

1) It is one MONSTER installation - over 110 MB last time I tried it.

2) It wreaks havoc for users who DO have Access installed, particularly if
they have a different version.



Thank you both for your replies. Jezebel, you are correct. Once I built an
MDE file, the run time library made itself known to me but the points
raised, especially the second, stopped me cold. The client does have A2K
installed on his system. However, he owns a number of stores; some of which
will not have Access installed. I guess the next step is to find out if he
intends to install Access at the other stores, or does he want to deal with
the runtime files.

Again, thank you both for your assistance.

--
Robert Berman
Vulcan Software Services
Th********@NOSP AM.earthlink.ne t
Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
5605
by: Gerry Laenen | last post by:
Hi, I first created several ActiveX DLL's which interact with each other, an SQL Server database, ... Some Active DLL's use different references: i.e. one that does not interact with a database, does not need de ADO reference. Above these different ActiveX DLL's, I have created another ActiveX DLL which has references to the other compiled...
4
3774
by: Tony | last post by:
After installing the A2003 developer extensions I expected the "VBA Package and Deployment Wizard" to be available in the Add-In Manager dialogue box. It did not appear. No option appeared. What more must I do to make the Package and Deployment Wizard available? Tony
4
6458
by: chris | last post by:
hi guys and girls I have 2 problems that are driving me crazy! 1/ I have a front end mde, and back end mdb, that I have packaged and installed successfully in the past on both Win98 and XP Pro PCs. Since XP Pro PS2 OEM version is installed on a new box, Ive found I get the following ERROR Message Dialog Box, when I go to install my...
6
6292
by: tdmailbox | last post by:
I developed an access database in access 2003(keeping my database in the access 2000 format). It has been fully tested to be access 2000 compatible and works great. I am trying to package the final version however and when I tell it to create a shortcut it includeds the path to access 2003 in the shortcut C:\Program Files\Microsoft...
5
11154
by: Geri Reshef | last post by:
In the VB6 I used the "Package & Deployment Wizard" to create an installation package. I didn't find the VB.Net equivalent. Does anybody knows where or what is it?
6
4728
by: jt | last post by:
Using VB.NET 2003 and wanting to make a setup for my program. In VB6 there is package wizard but being a newbie can't seem to find the package wizard in VB.NET. Any help is surely appreciated. Thanks, jt
1
3879
by: DennisT | last post by:
Problem with Package and Deployment Wizard. My VB6 application compiles and runs fine. However, when I try to use the Application and Deployment Wizard to create installation files, the process aborts without any error message just after I depress the package button. Can anyone suggest a fix or a reason why this is happening? I can create...
1
2671
by: vick | last post by:
I installed Visual Studio 2005 Professional Ediction in order to create a 2003 Access Deploymnet package so my client could run the Access system I created on all their computers without having Access installed. This seemed to wipe out the choice of selecting the Packaging wizard choiceI had previously. How do you run the packaging wizard to...
1
2599
by: RandomElle | last post by:
Can anyone help me out with locating & using the package and deployment wizard for Access 2003? I have searched for HOURS and cannot find the Package & Deployment wizard for Access2003 anywhere on my machine. It's supposed to be under Program Files/Microsoft Office/Package & Deployment.... It's not there and I don't have a folder with anything...
0
7789
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7707
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8037
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8215
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
8086
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6432
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3737
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1325
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1048
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.