i have designed a website and now i would like to add a members area. To do this I would need to use a form and an access data base. I used frontpage to make this website and i tried to like the form and the database but it wont work. can anyone tell me what you have to do to use an access databse in frontpage?

Originally Posted by Apocylipse

i have designed a website and now i would like to add a members area. To do this I would need to use a form and an access data base. I used frontpage to make this website and i tried to like the form and the database but it wont work. can anyone tell me what you have to do to use an access databse in frontpage?

If you are looking for some sort of built in feature to do this in frontpage, I don't think it has one. You'll may have to do it manually.

Is the member area just a password protected area? I may be able to help.

If your planning to move into ASP driven websites then you really should drop the WYSIWYG editor's and learn to code by hand. Like ACW said, frontpage won't be able to do it for you. Dreamweaver has this capability, but I strongly urge you to learn to do it yourself.
You can find plenty of code samples on the net:
www.aspin.com
www.4guysfromrolla.com

Here is something I put together about ASP that hopefully might help somehow.

You and others can have access to a database hosted on the Web from any location that has a browser with an Internet connection.

The Web database concept makes sense if you and your people want to do work in various locations in or outside the office and still be "plugged" in.

For example you could have employees enter timesheets or have sales reps log their contacts. Or perhaps you'd like customers to be able to check the status of their orders online without having to call the company.

If you want a Web database, typically what would happen is that a database such as Access or MySQL (basically just consisting of tables) would be put on the Web.

Then "dynamic" Web pages (actually ASP pages which include VBScript, HTML, and/or JavaScript) would be created acting like the old desktop database's queries, forms, and reports to access the database - all hosted on a Web Server.

Dynamic Web pages are similar in many ways to regular HTML pages. But they are "live" because the user can read from and write to information in the database. An example where you can login and add, edit, or view fictional customers and invoices is at http://www.bullschmidt.com/login.asp

Not all Web hosts will handle dynamic Web pages but many do. The Web hosts that can handle ASP pages usually have a Windows 2000 or Windows 2003 operating system running an IIS Web server.

Here are a few good ASP sites:
o ASP101 Samples - http://www.asp101.com/samples
o W3Schools ASP Tutorial - http://www.w3schools.com/asp
o Microsoft VBScript Language Reference - http://msdn.microsoft.com/scripting/...bscripttoc.htm

And the following newsgroup is good:
microsoft.public.inetserver.asp.general

Or for a "quick and dirty" generic ASP open source solution to putting databases on the Web that just requires setting up a configuration page for each table or query and uploading the database to the Web as long as there is an autonumber field in each table (and you'll probably also separately want to create login capabilities), perhaps try something like this:
GenericDB by Eli Robillard
http://www.genericdb.com and then click on the Tips link to see an example

Check this one, You will find a lot of info about about FP and databases.

http://www.outfront.net/spooky/

If your host is not a teenager trying to make a few bucks, he should be able to create a database for you if you ask him or you should have the possibility to create the database by yourself through your control panel. My customers can create Access and MySQL databases through their control panel.