472,331 Members | 1,390 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,331 software developers and data experts.

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 6099
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 misunderstanding.
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 misunderstanding.
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
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...
28
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...
2
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...
8
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...
2
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...
10
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...
49
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,...
5
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...
6
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...
2
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...
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
0
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...

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.