Converting an access databse to frontpage..

Hi
This is the situation..
I have developed a database that works ok..
Lots of importing and exporting, synchronization etc..
It works ok but putting it on a website and having people access the databse direct seems to me to be the best way forward.
So thats what I am about to do..
I have a friend who has 2003 server setup for his business and has Frontpage Extensions installed and Sharepoint Services installed and I have sucesfully published a website to his server and taht works fine.
I can query a database and get results - so far - ok but I want to take the forms I have arleady designed in Access and convert them for use on the website..
How do I do that?
I do an export and get a form that asks me a bunch of question?
What does this do?
Am I going about this the wrong way?
Am I opening up a can of worms?
Should i stop now?
Do i need to learn a load of ASP?
Cheers
Mat
funkkubeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

KenAdneyCommented:
short bad answer...FrontPage has webbots that can do this but I prefer (since I'm using IIS for my servers) to do it with ASP.

http://www.js-examples.com/page/asp__update.html
http://www.webwizguide.com/asp/tutorials/updating_data_from_database_pt2.asp
http://www.sitebuilder.ws/frontpage/tutorials/update.htm

to get you started...

There's no tidy way to convert the Access forms to HTML forms since Access has lots of stuff about the forms (font size, colors, etc.) that are included in the form.  It's usually easier just to make new HTML forms.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.