Solved

Create a web-based alternative from a Microsoft Access Form & Database

Posted on 2009-04-07
1
506 Views
Last Modified: 2012-05-06
Hello,

I have a project I built in Microsoft Access that, in my mind, turned out very well.

The project manager, having utilized the Access database, now wants it to be web-based so that we can rid Access.

I wondered if you could take a look at the database and its functionality and recommend the best approach I could take in rewriting it for the web. I am kind of leaning towards using PHP and Javascript at this point, as arduous as it will be.

The database can be found at: www.irvineproducts.com/GradingSystem.accdb

I know there are no easy "conversion" tools, having spent hours trying. I would like something that is platform independent - i.e., can run on either a Windows or Linux server and is not bound to using ActiveX, ASP, etc.

Someone suggested I experiment with Adobe Flex and I was a tad disappointed in the results.

Let me know if you have any advice.

Thank you,
Joseph
0
Comment
Question by:jkeagle13
1 Comment
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
Comment Utility
As you said: There is no simple tool to do this. You won't get the same "look and feel" of a desktop application on a web app, of course, but then desktop apps typically don't have the agility of web apps, so there are tradeoffs.

Java is the obvious choice in terms of platform independence, but there can be a steep learning curve associated. Pretty much any of the major web languages will work, since virtually any server - Windows or xNix-based - can be configured to run them.

For my money, ASP.NET is a great choice for someone with MS background skills, but it's certainly not 100% platform independent.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Envision that you are chipping away at another e-business site with a team of pundit developers and designers. Everything seems, by all accounts, to be going easily.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
The viewer will learn how to count occurrences of each item in an array.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now