Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
    >>

    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page