Solved

what are some simple, inexpensive ways to build an access application for the web

Posted on 2014-09-04
3
236 Views
Last Modified: 2014-09-10
I have completed a simple Access 2010 application (very little VBA) for my church. It contains tables for families, family members, and the ministries (food pantry, hospice care, ushers, etc) that family members volunteer for. It runs well on my PC and I have installed it on other PCs using Microsoft's Runtime.

I would like the app (logic and data) to be housed on the internet.   I think I would need a server someplace and I would need to learn more about SQL. What advice can you give me to get started?
0
Comment
Question by:SowleMan
[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
  • 2
3 Comments
 
LVL 19

Accepted Solution

by:
Montoya earned 350 total points
ID: 40304401
most people will tell you to abandon Access.. it's really not very good for multiple users.
So this leaves you with using some of the tools that are out there. Most hosting companies will give you access to mySQL. The good news is that you can pretty much use the data structure you have today and basically just 'port it over' to mySQL.
The not so awesome thing is that you will have to re-build your pages, essentially your forms and reports.
This is also a matter of choice, but php is a very popular choice for that.

If you have the budget, you can go for a different solution, for example, FileMaker Pro and FileMaker Server... they would purchase "Server" with a number of concurrent licenses, you would build app and deploy it to users. App communicates with server. The nice thing about FileMaker is that it already has built-in templates for mobile deployment on Ipads, iPhones, etc... but it comes at a cost. However, the learning curve is not steep at all, whereas learning PHP, etc.. is arguably more difficult.
0
 
LVL 19

Assisted Solution

by:Montoya
Montoya earned 350 total points
ID: 40304406
0
 
LVL 27

Assisted Solution

by:Zberteoc
Zberteoc earned 150 total points
ID: 40304589
Access is not for web. Even if you decide to use it you still need some web app framework to build the app that will in turn talk with the Access database. Point is that you need to learn languages liek PHP, Java, ASP.NET, Django or Cherrypie with Pyhton and such,

You could also use services like: https://www.knackhq.com/features/
0

Featured Post

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

Question has a verified solution.

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

Thoughout my experience working on eCommerce web applications I have seen applications succumbing to increased user demand and throughput. With increased loads the response times started to spike, which leads to user frustration and lost sales. I ha…
In order to have all security and back ups taken care of, WordPress users can sign up for services with WP Engine.
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…

705 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