FrontPage and Access Data base

[RickRantilla]

I've built an Access 2003 data base which I want to integrate into my web site. I'm familiar with SQL. I'm using FrontPage 2003 for my web site. I am familiar with html and sort of understand the concepts of ASP and ASP.net. I'm hosting my site on a Windows server.

1) I need to secure the pages where users interact with the data base content. Since I'm on a Windows server, the FrontPage "registration wizard" won't work. Where can I find a good logon/user registration scheme?

2) Inside the secure area, users should only interact with records associated with their login ID. I'd prefer to use the FrontPage Database Results wizard to develop pages for this. I've figured out how to use the wizard to create SQL to interact with the data base, but I can't quite get the SQL statements to access page variables such as the loginID.

For example feeding the following SQL to the wizard:

SELECT * FROM BookSwaps
WHERE mail = " & Session('loginemail') & ";

creates the following code:

fp_sQry="SELECT * FROM BookSwaps WHERE mail = "" & Session('loginemail') & "";"

This conversion contains too many "" to build the string. Any idea how can I do this?

If this is too much for a specific answer, what are some good tutorals or other references for these issues?

Thanks in advance.

 

[rjn2001]

Try the ASP or SQL forums, they are going to be able to help you!

Have a good day

Richard Noon

http://www.davidmasonconsultancy.co.uk