IT Employment

General discussion


Microsoft Access vs Web Reports

By scminter ·
I currently have an in house application written in Microsoft Access and deployed as an application with MS Office Developer's Edition. The application is a front end reporting tool (EIS) for an oracle database. I also have 5 forms utilized by theapplication.
This cost me around $1,200 in software to purchase and deploy to an unlimited number of desktops within my organization.

Is there an alternative that you know of that I could use to produce reports and forms in a web page? Is therean alternative I could use as a desktop client?

I am looking to get out from under Microsoft's upgrade/licensing tyranny. I'm looking for ideas of software that might work and I'll explore.

Thanks for your help.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Microsoft Access vs Web Reports

by nikki96 In reply to Microsoft Access vs Web R ...
Collapse -

Microsoft Access vs Web Reports

by scminter In reply to Microsoft Access vs Web R ...

The price for WebFocus make it unattainable with my budget. Note that I spent only $1,200 for Microsoft Access for unlimited clients.

I appreciate your reply and would love to purchase something like WebFocus or Cognos if only I had the budget.

Collapse -

Microsoft Access vs Web Reports

by dbgirl In reply to Microsoft Access vs Web R ...

I would suggest that you try using Java to create your own solution if you are trying to get around upgrade/licensing issues. If you aren't familiar with Java, you could get a couple books and learn it. That would be your only out-of-pocket expense. And if you document what you do well enough, then keeping it current shouldn't be that big a deal.

Collapse -

by JimHM In reply to Microsoft Access vs Web R ...

Depends on what the reports do - are they drill down reports - or static reports - are they large and complex reports - medium complexity - or easy complexity -

You have left many question unanswered - but from doing research on Crystal report / Cognos / Webfoucs and other vendors. We have found them very expensive for open licensing of published reports.

So the question comes into play - what kind of report are you doing - how many of each - how many changes per week/month/year - how many viewers - estimate the cost to have them developed in house using DHTML/JDBC-Javascripts or pure Java - What is the cost of a Vendor solution with Hardware - training - creation -

Ours was over 1,000 reports per month, changed 25% changed monthly with another 1,000 reports created automatically - we recommeded Crystal - WebFoucs and last Cognos - they purchased Cognos - very expensive and not very functional.

You will need to study your environment - and report space. If it is as small as you say - I would create them inhouse with DHTML/Javascript-JDBC ...

Collapse -

by marv732 In reply to Microsoft Access vs Web R ...

Since you already have an Oracle licence why not have alook at HTMLDB? It's part of Oracle 10g and runs in or better.
Check out
It runs in the database and uses the Oracle provided Apache web server so no extra development kits or licencing involved and generates HTML apps very quickly using templates and wizards.
Well worth the effort IMHO.

Related Discussions

Related Forums