Solved

Creating online entry forms with Access 2007

Posted on 2013-11-25
3
226 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

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

910 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

16 Experts available now in Live!

Get 1:1 Help Now