How to use MS Access HTML for a local (Intranet) webpage
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
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
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.
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.
ASKER
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
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
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.
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/
Here is a tutorial to get you started : https://www.sitepoint.com/using-an-access-database-with-php/
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We are talking about the government, getting an exception to policy would be slim to none at my level.
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.