Solved

Web page to update Access Database

Posted on 2004-04-13
5
173 Views
Last Modified: 2013-12-24
Hi all

How do I create a web page that adds and updates entries in a MS Access database? The idea is to use an online form on that web page where information is inputted and than added to the database.

Thanks,

seb
0
Comment
Question by:sjc2309
[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
5 Comments
 
LVL 12

Accepted Solution

by:
rcmb earned 125 total points
ID: 10813198
To input data you need to create a form with text, drop-down, text-area, etc. boxes to gather the data. I recommend naming each form field the same as the database field you will be writing to (right click on the form field and edit the Name).

You have the form submit directly to the database by right-clicking inside the form (dotted lines) and select form properties
Select the option send to database, click on options to select the database connection you created earlier and select the table you desire to send the information to.

Click on the saved fields tab and match your form boxes to the fields you desire them to be written to.

I recommend clicking on the additional fields tab and removing anything in there.

Click ok once complete.

There are much more efficient ways to do this but if you are not familiar with writing ASP then this is probably the easiest way to get you to where you want to go. If you want more information let me know.

Are you desiring to edit (update) an entry once it is recorded? The information above only allows a user to input data.
RCMB

0
 
LVL 2

Expert Comment

by:thescot
ID: 10822288
why not use the use the data access pages available in ms access to create the inout form.
0
 
LVL 12

Expert Comment

by:rcmb
ID: 10822342
No problem with doing this except I have run into permission problems for external users. The form works great and add tremendous features rather quickly. If this is on an Intranet then I say go for it but if you plan on publishing this externally then I caution you on this.

You also have very little design control over this process. All of your design has to be done in Access and this is not a web development tool.

You may also have to adjust your security settings in IE to allow this to perform correctly.

Just some thoughts on the process. Personaly I am much more comfortable in creating in FrontPage or ASP to give me complete control over the process.

RCMB
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…

724 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