Web form ---- Access

  • Thread starter Thread starter lecoughlin
  • Start date Start date
L

lecoughlin

How would I create a web form that would allow users to submit data
that would then download into an access database?
 
Hi

If yusing Frontpage or ExpressionWeb just create a new page, select Insert,
Select form then make the form as you want - ensure that each box or other
item has a different name.
Right click the form.
Select save to database
Select options
Select create database
Select verify
Save and close.

This will create the form.
Publish t the web

When you open the webpage to import the "stuff".
Check folder mark FPDB or EWDB then select the folder
select Results (nless you have change the default)
Check to see if it working.

If it is then just import this data into you main dabase using an append query

You can either us the wizard - get external data in access

or (better) see this post I did a while ago for details of how to import
data from an external database into you main database

http://groups.google.com/group/microsoft.public.access/browse_thread/thread/ca5839ab4cca4358

good luck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top