bob-hytekltd
asked on
Web browser as a front end to a microsoft access database?
I have an application in VB6 with a Microsoft Access database used by over 3500 users worldwide. My users are not allowed to use Microsoft .NET Framework or JAVA so I have to go a different route.
I am thinking about going HTML5 and PHP to connect to the Access database and a complete re-write of the application. My concern is what my users will need to add to their systems to run a browser-based application with PHP.
Can anyone provide some guiding input???
I am thinking about going HTML5 and PHP to connect to the Access database and a complete re-write of the application. My concern is what my users will need to add to their systems to run a browser-based application with PHP.
Can anyone provide some guiding input???
Here's some framework's to look into which could save a substantial amount of time.
http://www.kendoui.com/
http://dhtmlx.com/
Others...
http://komelin.com/en/5tip s/5-most-p opular-htm l5-respons ive-framew orks
http://www.kendoui.com/
http://dhtmlx.com/
Others...
http://komelin.com/en/5tip
My concern is what my users will need to add to their systems to run a browser-based application with PHP.
Depending on what you crete, the client side may not need anything.
On the server side where the Access database is located they will need IIS running with PHP installed.
Note: If you will be hosting the database on your own web server then you can use ASP.NET without having to install any .NET stuff on the client
My users are not allowed to use Microsoft .NET Framework or JAVA so I have to go a different route.Curious what operating system they're on ...
A web application runs in the web browser, IE, Firefox, Chrome, Safari, etc. Basically the only thing your clients will need is a web browser, which they certainly have. If your application doesn't have some special needs that are browser specific it will run in any of them.
Build your app using PHP or some other web app platform and just let your clients know when is done and what the URL is.
Build your app using PHP or some other web app platform and just let your clients know when is done and what the URL is.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The restrictions make sense from an attack surface reduction perspective, although other approaches are available (i.e. running applications (Java, .Net, etc.) in dedicated protected virtual space), etc., using a product such as Invincea. I probably don't need to go into how many 0-day exploits Java has had this past year.
In the end, all you'll need at a minimum is a web server capable of using PHP. I just converted a VB6 application myself to a web based application. I used the Kendo UI framework (requires Javascript enabled browsers) and MariaDB as the replacement back-end database server.
The web server can either be packaged and installed locally on each users machine or hosted and globally accessible to your users via a web browser, depending on your requirements. While the latter seems to be the easier approach, the "right" way will be completely dependent on your organizational goals and requirements.
In the end, all you'll need at a minimum is a web server capable of using PHP. I just converted a VB6 application myself to a web based application. I used the Kendo UI framework (requires Javascript enabled browsers) and MariaDB as the replacement back-end database server.
The web server can either be packaged and installed locally on each users machine or hosted and globally accessible to your users via a web browser, depending on your requirements. While the latter seems to be the easier approach, the "right" way will be completely dependent on your organizational goals and requirements.
ASKER
The other comments were good and headed me in the same direction, but this response but it all together in a format I could best understand.
The users are police departments and do not allow access outside their network and the reason I can not host the website for my application. I could move to VB.NET but I've been programming for 40 years and VB.NET is pretty bad. I'd rather move it to a server-side application but also have the problem that police departments may not take lightly to having to run IIS on their servers... even thought 99% of them already do for their own applications. But I can't depend on it.
I am running a survey now to determine how many agencies run IIS and PHP. If it's 100% then, I'm good to go. If it's 99.999999999%, I have to go a different route.
Thanks,
bob...
=======
The users are police departments and do not allow access outside their network and the reason I can not host the website for my application. I could move to VB.NET but I've been programming for 40 years and VB.NET is pretty bad. I'd rather move it to a server-side application but also have the problem that police departments may not take lightly to having to run IIS on their servers... even thought 99% of them already do for their own applications. But I can't depend on it.
I am running a survey now to determine how many agencies run IIS and PHP. If it's 100% then, I'm good to go. If it's 99.999999999%, I have to go a different route.
Thanks,
bob...
=======
For all intents and purposes, a front end application could be created without specialized add-ons, as all processing is done server-side via PHP.
Here's an example of connecting to an Access/JetSQL db file via PHP:
Open in new window
If you're planning on distributing your application (as opposed to hosting it) with the intent of having users run it locally, then you'll need to include a web server, php, and other support files with your distribution. Take a look a XAMPP, httpdx, etc.