How to use MS Access HTML for a local (Intranet) webpage

Russ Cummings
Russ Cummings used Ask the Experts™
on
I have an Access DB, running on an office PC.
I'd like have a webpage that displays data from this DB.
I have a shared drive that can be used so others can see this webpage - without directly addressing Access.
This page will be designed as a dashboard, and will have a wide variety of links, tables, charts.
How do I setup a connection & display the data?
Thank you in advance.
Russ
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Ryan ChongSoftware Team Lead

Commented:
This page will be designed as a dashboard, and will have a wide variety of links, tables, charts.
How do I setup a connection & display the data?

You can try to host your web page in a local (intranet) web server, such as IIS, so that you can creating a dashboard with some server side programming languages, such as ASP.NET, PHP, and so forth with some client side scripting languages, such as Javascript, CSS, etc to create the interactive web pages.
Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018

Commented:
Access really isn't meant for this, not even close!  You would be MUCH better served to use MySQL and PHP or some other technology.  Another option would be to output the stats in say csv and use  a javascript library to chart the data.

I'm not saying it can't be done, I'm saying it shouldn't be done.  Set yourself up for success and use the right tools to empower you.
Russ CummingsIT Consulant

Author

Commented:
In other instances - where I have a Domain on a server (which has PHP) I do understand exactly what needs to be done.
In this case the Network Administrator will not allow any software to be installed on any PC.
I do have MS Office pre installed.
Do I have any options?
Russ
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

Ryan ChongSoftware Team Lead

Commented:
In this case the Network Administrator will not allow any software to be installed on any PC.
you will need to allow your Access db accessible from your web server, to establish the db connection to retrieve the data.

if access of Access db (at pc) is not allowed, you will then need to think for alternative solutions, but in particular, you can follow what Daniel had suggested, which is to install the MySQL and make it as your primary db server.
John TsioumprisSoftware & Systems Engineer

Commented:
PHP interacts rather nicely with Access...just activate the driver,make the necessary connection and off you go.
Here is a tutorial to get you started : https://www.sitepoint.com/using-an-access-database-with-php/
President / Owner CARDA Consultants Inc.
Distinguished Expert 2018
Commented:
Since apparently all web technologies are out because they all require installations of IIS, Apache, ... why not create a regular Access database and provide each use with a copy of the front end?  You can easily create a dashboard in Access.

The javascript option is still viable.

Network Administrator will not allow any software to be installed on any PC
IT is there to facilitate, not dictate (except in the case of security).  If you need something to solve a business issue, you bring that to management, and they will kindly inform IT to make it happen.
Russ CummingsIT Consulant

Author

Commented:
We are talking about the government, getting an exception to policy would be slim to none at my level.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial