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
Solved

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

Posted on 2009-04-07
1
517 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
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
Color can increase conversions, create feelings of warmth or even incite people to get behind a cause. If you want your website to really impact site visitors, then it is vital to consider the impact color has on them.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

790 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