Solved

Creating online entry forms with Access 2007

Posted on 2013-11-25
3
225 Views
Last Modified: 2013-11-29
hi Folks
If I wanted to create online entry forms with Access 2007...what are my options? This is for someone else (it's unlikely they will be upgrading to Access 2010 anytime soon and no, they don't use Sharepoint)...Microsoft has gotten rid of Data Access Pages which used to be a solution in earlier versions...I'm thinking of telling them to use SurveyMonkey... LOL
0
Comment
Question by:agwalsh
3 Comments
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 200 total points
ID: 39674208
Other than SP, there are no methods to put your Access db on the web using native methods. Access 2010 introduced the "web database", but this requires you to either purchase hosting, or setup your own SP system. Access 2013 includes the cloud-based system, which would probably be a better choice, but (again) this is subscription-based.

There's also www.eqldata.com, which can host their database as-is. It subscription-based as well.

Or you could setup a Remote Desktop Server (RDS) system and allow users to log in remotely and run the db.

If your "someone else" truly needs an app available to different people in a web-browser, then either move up to 2010/2013, or develop the application in a web language like ASP.NET, PHP, etc.
0
 
LVL 34

Accepted Solution

by:
PatHartman earned 300 total points
ID: 39675604
Access 2007 has the ability to sent/receive emails with embedded data.  You can specify HTML or InfoPath.  That might work if this is simply for data collection such as surveys.  You set up a special folder so Access knows which emails it is supposed to interact with and it will read the data and add it to your tables and move the email to a processed folder.  I think it can also update data.  I haven't had occasion to use it so I don't have an example but I did play with it a few years ago to see how it worked.  I think it was viable if you worked with the Access GUI but I think I had trouble controlling it with code.  it's worth a look though.
0
 

Author Closing Comment

by:agwalsh
ID: 39684850
Not exactly what I wanted to hear but it's given me an option :-)
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

This article will show you how to use shortcut menus in the Access run-time environment.
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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 use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

744 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

15 Experts available now in Live!

Get 1:1 Help Now