Do I need a Multiuser/ Runtime Environment?

I would appreciate any comment.

I want MS Access to act as a reporting tool accessing Oracle tables.

The Oracle database is populated by another database application, but
this application cannot create the report I want in this situation. I
can easily develop the application I need to create the report and I'd
like to deploy this tool as a published application over Citrix so
users can simply fireup Access, run the report and print.

I have no experience with setting up Runtime/ multiuser environments
with Access; so my ignorant question is if the database is just
throwing out a report from linked tables over ODBC (with a few simply
queries in the background) do I have to deal with settting up the
runtime application or can access handle that on it's own?

Luke

Re: Do I need a Multiuser/ Runtime Environment?

"lukethegooner" wrote in message
news:e1a1d34a-3145-4985-9c56-392fd7d2142f@s19g2000prg.google groups.com...
>I would appreciate any comment.
>
> I want MS Access to act as a reporting tool accessing Oracle tables.
>
> The Oracle database is populated by another database application, but
> this application cannot create the report I want in this situation. I
> can easily develop the application I need to create the report and I'd
> like to deploy this tool as a published application over Citrix so
> users can simply fireup Access, run the report and print.
>
> I have no experience with setting up Runtime/ multiuser environments
> with Access; so my ignorant question is if the database is just
> throwing out a report from linked tables over ODBC (with a few simply
> queries in the background) do I have to deal with settting up the
> runtime application or can access handle that on it's own?

The runtime IS Access (the exact same executable) so your question doesn't make
much sense. The advantage of using the runtime with Citrix is that your users
wouldn't have to own a valid license for Access. If they already have that then
the runtime provides no additional value.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Re: Do I need a Multiuser/ Runtime Environment?

On Wed, 23 Jan 2008 00:29:57 GMT, "Rick Brandt"
wrote:

And indeed the runtime would provide a bit of negative value, since it
can't do all that the full version can (e.g. query by form).

-Tom.


>"lukethegooner" wrote in message
>news:e1a1d34a-3145-4985-9c56-392fd7d2142f@s19g2000prg.googl egroups.com...
>>I would appreciate any comment.
>>
>> I want MS Access to act as a reporting tool accessing Oracle tables.
>>
>> The Oracle database is populated by another database application, but
>> this application cannot create the report I want in this situation. I
>> can easily develop the application I need to create the report and I'd
>> like to deploy this tool as a published application over Citrix so
>> users can simply fireup Access, run the report and print.
>>
>> I have no experience with setting up Runtime/ multiuser environments
>> with Access; so my ignorant question is if the database is just
>> throwing out a report from linked tables over ODBC (with a few simply
>> queries in the background) do I have to deal with settting up the
>> runtime application or can access handle that on it's own?
>
>The runtime IS Access (the exact same executable) so your question doesn't make
>much sense. The advantage of using the runtime with Citrix is that your users
>wouldn't have to own a valid license for Access. If they already have that then
>the runtime provides no additional value.

Re: Do I need a Multiuser/ Runtime Environment?

On 23 Jan, 00:29, "Rick Brandt" wrote:

> The runtime IS Access (the exact same executable) so your question doesn't=
make
> much sense. =A0The advantage of using the runtime with Citrix is that your=
users
> wouldn't have to own a valid license for Access. =A0If they already have t=
hat then
> the runtime provides no additional value.

OOOOOOOOOOOOOk,

Thanks for the comments so far, gretly appreciated ... as you can
guess I'm not much of a blackbelt in deplying Access ... So my
question from those replies is ...

So if I were to install Access on the production Citrix server(s),
link it to the Oracle tables, setup the queries and reports as
required, make an application then publish it to 10 users it would
work fine?

Luke

Re: Do I need a Multiuser/ Runtime Environment?

On Wed, 23 Jan 2008 05:59:51 -0800 (PST), lukethegooner
wrote:

If it didn't I'd look at you rather than at Access :-)
-Tom.


>On 23 Jan, 00:29, "Rick Brandt" wrote:
>
>> The runtime IS Access (the exact same executable) so your question doesn't make
>> much sense.  The advantage of using the runtime with Citrix is that your users
>> wouldn't have to own a valid license for Access.  If they already have that then
>> the runtime provides no additional value.
>
>OOOOOOOOOOOOOk,
>
>Thanks for the comments so far, gretly appreciated ... as you can
>guess I'm not much of a blackbelt in deplying Access ... So my
>question from those replies is ...
>
>So if I were to install Access on the production Citrix server(s),
>link it to the Oracle tables, setup the queries and reports as
>required, make an application then publish it to 10 users it would
>work fine?
>
>Luke

Re: Do I need a Multiuser/ Runtime Environment?

"lukethegooner" wrote in message
news:796510d2-857d-4eb3-87f7-881f73781721@i72g2000hsd.google groups.com...
Thanks for the comments so far, gretly appreciated ... as you can
guess I'm not much of a blackbelt in deplying Access ... So my
question from those replies is ...

So if I were to install Access on the production Citrix server(s),
link it to the Oracle tables, setup the queries and reports as
required, make an application then publish it to 10 users it would
work fine?

Sure, but to be legal all users would also have to have Access installed on the
PC that they use to connect to the Citrix server (or at least hold a license for
it).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Re: Do I need a Multiuser/ Runtime Environment?

"Rick Brandt" wrote:

>Thanks for the comments so far, gretly appreciated ... as you can
>guess I'm not much of a blackbelt in deplying Access ... So my
>question from those replies is ...
>
>So if I were to install Access on the production Citrix server(s),
>link it to the Oracle tables, setup the queries and reports as
>required, make an application then publish it to 10 users it would
>work fine?
>
>Sure, but to be legal all users would also have to have Access installed on the
>PC that they use to connect to the Citrix server (or at least hold a license for
>it).

Or use the Access runtime.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/