Solved

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

Posted on 2009-04-07
1
523 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 24089799
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article was originally published on Monitis Blog, you can check it here . Today it’s fairly well known that high-performing websites and applications bring in more visitors, higher SEO, and ultimately more sales. By the same token, downtime…
The viewer will learn how to count occurrences of each item in an array.
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.

690 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