Publish access form on a website

I created a form in Access. I would like to put up the form on our website so people can enter their information. We need to review the data before they get into our database.
I am actually stuck about how to publish the form. I thought it was an easy thing, but I guess not... I tried to export it as an html but what I got was not the form (but something like the fields in one row).
Or should I create the form in PHP? But then how do I connect it with our database? We have to reenter the data. (I thought the data could go into the database fro the web but would be marked as not reviewed.)

Any help appreciated. (And sorry if I asked something stupid!)

kotkoda

Newbie Poster

8 posts since Jun 2008

Reputation Points: 10

Solved Threads: 0

3 Years Ago

0

Connecting to access with php is very simple. You will need to be able to access the IIS control panel to set things up. Otherwise you need to talk to the server admin to set an ODBC Connection for you. Also, make sure that the db is on the web server.

1.) Create an ODBC Connection. Here are instructions.
2.) Establish a connection through php (See the above link for more in depth examples):

<?php
$conn=odbc_connect("DSN","" ,"");//Replace DSN with your Data Source Name created in step 1
?>

Good luck!

buddylee17

Practically a Master Poster

697 posts since Nov 2007

Reputation Points: 232

Solved Threads: 137

3 Years Ago

0

So what you are saying is that I should (re) create the form in PHP? And suggesting using MySQL instead of Ms Access??
I can't find my IIS but I am pretty sure it can be installed (I am at a university).

Thanks a lot for your help!

kotkoda

Newbie Poster

8 posts since Jun 2008

Reputation Points: 10

Solved Threads: 0

3 Years Ago

0

Oh OK I think I can use MySQL from Microsoft Access... :)
Sorry I am a complete newbie!

kotkoda

Newbie Poster

8 posts since Jun 2008