Re: Do I need a Multiuser/ Runtime Environment?

"lukethegooner" <lukethegooner@xxxxxxxxx> wrote in message
news:e1a1d34a-3145-4985-9c56-392fd7d2142f@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • RE: updated numbers in report
    ... for making an input to the database. ... textbox will be located alongside with the combobox where the belonging ... belonging query for the report. ... ElapsedTime([Date First Time Onboard], ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Creating a report entirely through code
    ... In my case this is a very simple database, ... >> thus greatly increase the probability of corruption. ... >> button doesn't gray out after a compile, a control starts to ... >>>report and not a form where they have to enter data in. ...
    (microsoft.public.access.formscoding)
  • Re: Creating Access DB
    ... database and in the SQL database that your report needs. ... click the query tab. ...
    (microsoft.public.excel.programming)
  • Re: MSSQL$SBSMonitoring Database size (SBS2003)
    ... You can use the SQL Client Utilities to try and shrink the database. ... to delete over 90 day old information from the monitoring ... The server will start to collect new counter value ... Check 'View the usage report in Server Management' option. ...
    (microsoft.public.windows.server.sbs)
  • Re: Suggestion
    ... Datamarts allow you to create summarized data and improve the query response ... You have to choose the better source regarding the report you have to ... Detailed information can query your OLTP data sources. ... >> Keeping the historical vs. current data partitioned by database is ...
    (microsoft.public.sqlserver.datawarehouse)