Access 2000 Runtime

B

BobbyBob

Hi everybody and thanks to all the knowledgeable people who answer the
problems posed here. Over the years I have learnt a great deal from reading
other peoples postings. Now I have a problem of my own.

I have produced a program that I would like to distribute to users on a CD.
I have used the Package and Deployment wizard to produce the necessary files
and copied these to a CD. One of the files produced is called “Setup.exeâ€.
Users have to execute this file twice. The first time to install access
runtime and the second time to install the program. How can I produce a
“Setup.exe†file that will install both the Access Runtime and then my
program in one execution? I would also like the CD to “Auto Run†when it is
loaded.
 
B

BobbyBob

Hi Alex
Thanks for that. I haven't had time to sudy the info you pointed me to, but
it looks like it will answer the autorun proplem.

Any thoughts on the other problem would greatly appreciated. I can’t
believe that I an the only one who’s users have to use setup.exe twice.

Thanks again
 
T

Tony Toews [MVP]

BobbyBob said:
I have produced a program that I would like to distribute to users on a CD.
I have used the Package and Deployment wizard to produce the necessary files
and copied these to a CD. One of the files produced is called “Setup.exe”.
Users have to execute this file twice. The first time to install access
runtime and the second time to install the program. How can I produce a
“Setup.exe” file that will install both the Access Runtime and then my
program in one execution? I would also like the CD to “Auto Run” when it is
loaded.
Click to expand...

1) Access 2000 will not have any security patches in about a year or
so part of Microsoft's software life cycle management. Therefore I'd
at least suggest A2003 runtime, if you have it, and A2007 runtime as
it is free.

2) So what happens if they already have a version of Access installed?
Installing your version of A2000 could really cause a lot of problems.
You're better off using the Inno Installer scripts which Albert has
created which only install the runtime if it is required.

Sample inno script which checks to see if a version of Access is
installed. If not it tells you to install a runtime version of
Access. If installed then it continues to install your FE MDE and
other assorted files.'
http://groups.google.com/group/microsoft.public.access/msg/10e3fc9234660872?hl=en

Sample inno script which "wraps" the package wizard install into a
single .exe
http://groups.google.com/group/comp.databases.ms-access/msg/4aa1b33a191bf1f8?hl=en

Deploying updates to your software in a Runtime environment for Access
2007
http://www.members.shaw.ca/AlbertKallal/RunTime/InstallExample.htm

Tony
 
B

BobbyBob

Thanks for your comments and advice.

It sounds like I need to move with the times, and use A2007 and A2007
runtime for application development.
I have never used ADO in A2000, only used DAO.
Is it possible to use DAO in A2007 ?
 
B

BobbyBob

How big are the A2007 runtime files ?

Tony Toews said:
1) Access 2000 will not have any security patches in about a year or
so part of Microsoft's software life cycle management. Therefore I'd
at least suggest A2003 runtime, if you have it, and A2007 runtime as
it is free.

2) So what happens if they already have a version of Access installed?
Installing your version of A2000 could really cause a lot of problems.
You're better off using the Inno Installer scripts which Albert has
created which only install the runtime if it is required.

Sample inno script which checks to see if a version of Access is
installed. If not it tells you to install a runtime version of
Access. If installed then it continues to install your FE MDE and
other assorted files.'
http://groups.google.com/group/microsoft.public.access/msg/10e3fc9234660872?hl=en

Sample inno script which "wraps" the package wizard install into a
single .exe
http://groups.google.com/group/comp.databases.ms-access/msg/4aa1b33a191bf1f8?hl=en

Deploying updates to your software in a Runtime environment for Access
2007
http://www.members.shaw.ca/AlbertKallal/RunTime/InstallExample.htm

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/
Click to expand...
 
B

BobbyBob

Thank you for your comments.

Sorry, but can you just confirm that the possible problems Tony Towes
mentioned should not arise if I continue developing with A2000 but use A2007
runtime instead of A2000 runtime.
 
T

Tony Toews [MVP]

BobbyBob said:
Thanks for your comments and advice.

It sounds like I need to move with the times, and use A2007 and A2007
runtime for application development.
I have never used ADO in A2000, only used DAO.
Is it possible to use DAO in A2007 ?
Click to expand...

Yes, DAO works just fine in A2007.

Tony
 
T

Tony Toews [MVP]

BobbyBob said:
Sorry, but can you just confirm that the possible problems Tony Towes
mentioned should not arise if I continue developing with A2000 but use A2007
runtime instead of A2000 runtime.
Click to expand...

The problems I mention in my paragraph 2) happen no matter what
version of Access. To think of it another way their current
version of Access grabs hold of the MDB file extension (as well as
others such as MDA and MDE). So your version of Access then grabs
the file extensions. If their version is different than yours there
could be big problems.

Tony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Runtime 2016 2
Descenders clipped 0
2000 Runtime 2
Runtime error R6034 0
Access 2000 running (or not) in Vista 64 bit - need help! 1
How do i delete an old Outlook account from ex employers? 1
Datepicker is not included in runtime 0
Sub projects added as read only in Master file which are saved on sharepoint 1

Top