Do I need a Multiuser/ Runtime Environment?

[lukethegooner]

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

[Rick Brandt]

"lukethegooner" <lu***********@gmail.comwrote in message
news:e1**********************************@s19g2000 prg.googlegroups.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

[Tom van Stiphout]

On Wed, 23 Jan 2008 00:29:57 GMT, "Rick Brandt"
<ri*********@hotmail.comwrote:

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" <lu***********@gmail.comwrote in message
news:e1**********************************@s19g200 0prg.googlegroups.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.

[lukethegooner]

On 23 Jan, 00:29, "Rick Brandt" <[e-mail]:

The runtime IS Access (the exact same executable) so your question doesn'tmake
much sense. *The advantage of using the runtime with Citrix is that yourusers
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

[Tom van Stiphout]

On Wed, 23 Jan 2008 05:59:51 -0800 (PST), lukethegooner
<lu***********@gmail.comwrote:

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

>On 23 Jan, 00:29, "Rick Brandt" <[e-mail]:

>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

[Rick Brandt]

"lukethegooner" <lu***********@gmail.comwrote in message
news:79**********************************@i72g2000 hsd.googlegroups.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

[Tony Toews [MVP]]

"Rick Brandt" <ri*********@hotmail.comwrote:

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