Web enable?

C

Chirs

Can I web enable an access database on an intranet? specifically The frontend
(data entry ) and report generating functionality? YES or NO?
 
K

Keven Denen

Can I web enable an access database on an intranet? specifically The frontend
(data entry ) and report generating functionality?  YES or NO?
Click to expand...

YES

Keven Denen
 
G

GP George

Unfortunately, there really is no simple yes or no answer to this question.
Therefore, a Yes or No answer is pointless. Either one would be misleading
and incomplete, leaving you no better off than you were before.

If, by "web enable", you somehow expect to have your users connect to your
local mdb or accdb via a web browser, NO, they can't do that.
If, by "web enable", you want to know if there is a way to convert the
functionality in your Access mdb or accdb so that it CAN be reached via a
web browser, the answer is YES, subject to qualifications.

As always, the devil is in the details. So, what do you have in mind here?
How much effort are you willing to invest to make this happen?

George
 
N

NTC

Can I web enable an access database on an intranet? specifically The frontend
(data entry ) and report generating functionality?  YES or NO?
Click to expand...

No - not really. To go web based is a re-write using web server
architecture. If your organization has a solid private network and
Terminal Services you can extend Access to your users via this
method....but they use the FE - not a browser.

AccessTables.com is a service that replicates tables for multi
locations using the same database - again it is not browser based -
and oriented to overnight replication of tables.

EQLdata.com offers a service to browser enable an Access database -
kind of slow reponse time but may work ok for your application.
 
M

Mark Andrews

I agree in general that Access tables should not be used for anything
web-based (unless it's an Intranet with about 5 users).

I have been selling a product for about 10 years now that makes it possible
to produce a web interface to run Access reports. You build the web
interface to collect report criteria using normal web methods and you plug
in my solution (which is a COM dll) and an EXE that lives on your server.
It basically runs ONE instance of Access on your server and sits all day
getting report requests and creating pdf files. It has some scalability
limits (but comparable to some of the low-end web based reporting tools).

I used it at my last job and did about 5000 reports a month (about 1000
users in the company).

I used it for years and replaced numerous reporting systems that used
Crystal reports in the past.

Other low end reporting systems:
- Crystal reports
- Active Reports

High end
- SQL Server Reporting services
- Business Objects
- Cognos
- Microstrategy
- Actuate
- Oracle Reporting

My product might interest you?
http://www.rptsoftware.com/products/reportserver/

Mark
 
G

GBA

No - you need other products (or services)

some approaches to consider to accommodate a WAN requirement:

* rewrite to a web architecture
* Sharepoint
* Terminal Services - if you are all on the same intranet
* AccessTables.com - to share/replicate BE tables for multi location users
* EQLdata.com - browser enable service
 
Top