Solved

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

Posted on 2014-09-04
3
227 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
  • 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 26

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Foolproof security solutions has become one of the key necessities of every e-commerce or Internet banking website. If you too own an online shopping site then its vital for you to equip your web portal with customer security features that can allow…
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

867 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

24 Experts available now in Live!

Get 1:1 Help Now