Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Multi-user installs

Discussion in 'Information Technology' started by Rich Mogy, Jul 28, 2006.

  1. Rich Mogy

    Rich Mogy
    Expand Collapse
    Guest

    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
     
  2. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    > 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

    --
    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com
    http://www.members.shaw.ca/AlbertKallal
     
  3. Rich Mogy

    Rich Mogy
    Expand Collapse
    Guest

    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
    "Albert D.Kallal" <PleaseNOOOsPAMmkallal@msn.com> wrote in message
    news:%23oOu5YmkGHA.3512@TK2MSFTNGP03.phx.gbl...
    >> 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
    >
    > --
    > Albert D. Kallal (Access MVP)
    > Edmonton, Alberta Canada
    > pleaseNOOSpamKallal@msn.com
    > http://www.members.shaw.ca/AlbertKallal
    >
     
  4. Norman Yuan

    Norman Yuan
    Expand Collapse
    Guest

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

    "Rich Mogy" <rmogy@sbcglobal.net> wrote in message
    news:Nn2lg.25162$VE1.19277@newssvr14.news.prodigy.com...
    > 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
    > "Albert D.Kallal" <PleaseNOOOsPAMmkallal@msn.com> wrote in message
    > news:%23oOu5YmkGHA.3512@TK2MSFTNGP03.phx.gbl...
    >>> 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
    >>
    >> --
    >> Albert D. Kallal (Access MVP)
    >> Edmonton, Alberta Canada
    >> pleaseNOOSpamKallal@msn.com
    >> http://www.members.shaw.ca/AlbertKallal
    >>

    >
    >
     

Share This Page