473,554 Members | 2,291 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Using Access 2003 package wizard to package a database for a Access 2000 client

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 Office\OFFICE11 \

my client is running access 2000. I could not figure any way to change
the access application folder loction in the access setup. it is
assuming that since I have access 2003 the user of the appliaction does
too.

is there any way to fix this and still use the package wizard?

Nov 13 '05 #1
6 6289
This begs the question why would you need the runtime for this user if they
already got a version of ms-access?

Why not just email them the file, or perhaps use WinZip (it can remember the
directory you zip to, and even create it for you.). In fact, you can create
a self extracting zip file, and it will be a zillion times smaller then
suing the package and deployment wizard to JUST TRANSFER a mdb file to that
user.

Unless the end user needs the a2003 runtime, then I see no reason at all to
use the package wizard. Just zip and email the person the file!! You are not
installing the runtime here, and obviously you don't need it...so I think
you got the wrong tool here to just send a person a simple mdb file, and
they already got ms-access installed (and, worse, a different version). You
cannot effectually use, and install the a2003 runtime on machines that have
other versions of ms-access without some problems. Remember, while we call
it the runtime, it is in fact installing ms-access on the users machine, and
if you run different versions, then you do ask for more trouble..

I would either force the user to start using a2003 (or your runtime which
you can include for free), or just dump the use of the package wizard and
all the incredible complexities you are using here to simply transfer a mdb
file to that users computer.

You could perhaps try making a mdb install with the package wizard, and NOT
include the runtime files. This would *kind* of get you the same idea as
simply using WinZip to transfer the mdb file only..and NOT install the
runtime. This would of course only let you copy files..and would not setup
shortcuts. To make the shortcuts, you might as well just zip up the shortcut
for the user and send that....

I just don't see the need in this case to use the p&d, especially for a user
with a different versions of ms-access, and you are trying to transfer a mdb
file that is for a different version. The p&d for a2000 is for a2000 files.
the p&d for a2002 is for a2002 files,and the p&d for a2003 is for a2003
files.

I suspect perhaps there is something here I am missing, or misunderstandin g.
Please do feel free to expand on your question, as I might not be grasping
what you are trying to do?
..

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
http://www.members.shaw.ca/AlbertKallal
Nov 13 '05 #2
This begs the question why would you need the runtime for this user if they
already got a version of ms-access?

Why not just email them the file, or perhaps use WinZip (it can remember the
directory you zip to, and even create it for you.). In fact, you can create
a self extracting zip file, and it will be a zillion times smaller then
suing the package and deployment wizard to JUST TRANSFER a mdb file to that
user.

Unless the end user needs the a2003 runtime, then I see no reason at all to
use the package wizard. Just zip and email the person the file!! You are not
installing the runtime here, and obviously you don't need it...so I think
you got the wrong tool here to just send a person a simple mdb file, and
they already got ms-access installed (and, worse, a different version). You
cannot effectually use, and install the a2003 runtime on machines that have
other versions of ms-access without some problems. Remember, while we call
it the runtime, it is in fact installing ms-access on the users machine, and
if you run different versions, then you do ask for more trouble..

I would either force the user to start using a2003 (or your runtime which
you can include for free), or just dump the use of the package wizard and
all the incredible complexities you are using here to simply transfer a mdb
file to that users computer.

You could perhaps try making a mdb install with the package wizard, and NOT
include the runtime files. This would *kind* of get you the same idea as
simply using WinZip to transfer the mdb file only..and NOT install the
runtime. This would of course only let you copy files..and would not setup
shortcuts. To make the shortcuts, you might as well just zip up the shortcut
for the user and send that....

I just don't see the need in this case to use the p&d, especially for a user
with a different versions of ms-access, and you are trying to transfer a mdb
file that is for a different version. The p&d for a2000 is for a2000 files.
the p&d for a2002 is for a2002 files,and the p&d for a2003 is for a2003
files.

I suspect perhaps there is something here I am missing, or misunderstandin g.
Please do feel free to expand on your question, as I might not be grasping
what you are trying to do?
..

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
http://www.members.shaw.ca/AlbertKallal
Nov 13 '05 #3
you are totally correct. Since I am not including the runtimes the
packager is overkill. However my client needs me to provide him with
an install file as he uses a program called zenworks to push it to the
desktops. the users have zero access to their C: drives.

I can just zip the .mdb however then I dont see a way to create the
listing for my application in the program menu. The whole reason I was
using the packager was to get the program listed in the program menu.
I know I can make shortcuts but I dont know any way to get it listed in
the program menu.

Nov 13 '05 #4
you are totally correct. Since I am not including the runtimes the
packager is overkill. However my client needs me to provide him with
an install file as he uses a program called zenworks to push it to the
desktops. the users have zero access to their C: drives.

I can just zip the .mdb however then I dont see a way to create the
listing for my application in the program menu. The whole reason I was
using the packager was to get the program listed in the program menu.
I know I can make shortcuts but I dont know any way to get it listed in
the program menu.

Nov 13 '05 #5
Hey, you got a good answer!!

May I suggest in place of WinZip, you use the free inno installer.

It don't have a wizard to makes things easy..but the resulting install file
*should* be able to be pushed out via zenworks.

You can find more about the free inno installer here:

http://www.jrsoftware.org/isinfo.php

I have not used it, but have heard nothing but 100% praise for the
installer..

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
http://www.members.shaw.ca/AlbertKallal
Nov 13 '05 #6
Hey, you got a good answer!!

May I suggest in place of WinZip, you use the free inno installer.

It don't have a wizard to makes things easy..but the resulting install file
*should* be able to be pushed out via zenworks.

You can find more about the free inno installer here:

http://www.jrsoftware.org/isinfo.php

I have not used it, but have heard nothing but 100% praise for the
installer..

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
http://www.members.shaw.ca/AlbertKallal
Nov 13 '05 #7

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

Similar topics

3
2490
by: Colin Chudyk | last post by:
Hi, Here is my situation. Can anyone provide insight? I have developed a database in Access 2002. I am planning to distribute it as a split MDE (front) / MDB (back) to be used by the Access runtime and also full-version. Some of the client workstations will have Access 2002 installed. Most of them will have the runtime installed. ...
28
2625
by: Neil Ginsberg | last post by:
I have a client who is using Access 2002/2000 (the database itself is written in 2000), and is considering migrating to Access 2003. Any recommendations on whether Access 2003 is worth the migrate, or should he stick with 2002? Thanks! Neil
2
1944
by: Jennifer B. | last post by:
Hi Every Body: I hope this is to the right post. I apologize if I am incorrect. Could anyone please answer one or any of the following questions for Access 2003: - Maximum size of an Access database (after split) - speed of Access using a Citrix server (any server for that matter, will it affect the processing time of other database...
8
5256
by: deko | last post by:
Is it possible to develop an Access app in Access 2003 that will run on Access 2000? Is it just a matter of selecting "Access 2000" from the Default File Format drop down list on the Advanced Tab of the Options dialog? I need to do some quick work for a client that runs Access 2000 and I've only been doing working on 2002/2003 projects...
2
1840
by: Andy Davis | last post by:
If Access 20003 is installled on a computer witth Access 2000 runtime also installed can this cause problems? Have uninstalled the runtime application as a precaution, (however this was after the Access 2003 was installed), but still can't view any databases when using Access 2003. After selecting a database to open all that comes up is a...
10
6091
by: Lauren Wilson | last post by:
I have a desperate short term need for a way to install Access 2003 runtime on client computers. I have the proper license to do so but I cannot seem to find the files to do it like we did with the old Access 2000 Runtime. Also, I cannot use the MS Package & Deployment wizard because it won't allow us to install our app into the specific...
49
3186
by: Mell via AccessMonster.com | last post by:
I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code, etc? Please explain -- Message posted via http://www.accessmonster.com
5
1747
by: Ecohouse | last post by:
I'm using VB and an Access 2003. The db was originally created in Access 2000, but the computer had to have things reinstalled and now has Access 2003. So I was wondering if there are any compatibility issues using the two programs. I know that when using data controls you can select Access 2000 for the connect property. This VB program...
6
2784
by: Donald Grove | last post by:
I do programming in Access 2000 and 2003. I don't have a copy of 2003 myself, though. I have read about the adp software that comes with Access 2003, that converts an application to an access front end with a SQL server backend. It sounds like a good way for me to begin to learn about SQL server. I have thought about just shelling out...
2
8337
by: mbsevans | last post by:
New user here. I have constructed a database to track basic employee information. I wish to place finished database on a the network. I need to obviously retain full admin persmissions for all aspects of the database. More importantly I need to allow one clerical user to enter data and thats it. Now...I have been through various explanations...
0
7611
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
7812
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
8051
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
7894
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
5162
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3561
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2026
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1145
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
850
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.