Multi-user installs

[Rich Mogy]

Hi All,
I'm sure this is common place, but I would like to know how to do it.

I have an Access database that gets updated daily through SQL queries to an
SQL database. I then run some reports. The whole process has been tested
and runs quite well and does exactly what I want it to do.

Now I would like to transfer the running of the reports to a co-worker who
doesn't have Access on his workstation. What do I need to do to accomplish
this. How do I need to change my macros or will that be necessary.

Rich Mogy

 

[Albert D.Kallal]

I have an Access database that gets updated daily through SQL queries to

an SQL database. I then run some reports. The whole process has been
tested and runs quite well and does exactly what I want it to do.

Now I would like to transfer the running of the reports to a co-worker who
doesn't have Access on his workstation.

ok, so, this new user is not going to be knowledge about ms-access. The
building of quires, writing code etc. thus SHOULD NOT be needed, or
*assumed* by these end users..

Assuming you built some nice report prompt screens, such as shown here:

http://www.members.shaw.ca/AlbertKallal/ridesrpt/ridesrpt.html

What do I need to do to accomplish this. How do I need to change my macros
or will that be necessary.

You don't need to change your macros, but it has to be assumed that you
spent some time building a nice easy to use application. This nice easy to
use means that this new user will not have to be trained in using ms-access
(especially since you state that the user will not even have ms-access!!).

Once you have a polished appcation in which the user does not need to know
ms-access, you are then ready to deploy your application. Ms-access does
have royally free runtime edition. This edition can be installed on
computers that don't have ms-access.

You will need the developer edition of ms-access to build this package for
you.

You can read about it here

http://www.granite.ab.ca/access/developereditionfaq.htm

 

[Rich Mogy]

Thank you for your response -- I'll check the web sites out -- I have an
interface, but it sounds like its the run-time edition I need. Thanks a lot

 

[Norman Yuan]

Or it might be very simple to buy and install Access on that user's
computer.