Secure Data

[frontpagecustoms.com]

I am looking for a secure method to store user data in a database.
Currently the site is set up with MS Access, however I hear there are
several downsides... 1. Number of concurrent users is limited, 2.
Slower than other databases available, 3. One of the least secure
methods (posts your data in a subfolder instead of on a secured
server).

Here's my issue. I have a MS SQL database access on my current host,
but I am unable to create a "database connection" with it because of
the security. This means I have to do all of the asp coding by hand
(say goodbye to GUI). Unfortunatly, I do not know the asp coding and
rely on the db wizards which use the db connection.

Are there any sugguestions on how to secure the Access Database, or
are there other data servers out there what will accomplish my goals?

 

[Thomas A. Rowe]

1. An Access database can handle 5000 to 6000 connections per hour depending on how ASP code was
written. You need to learn how to hand code, as there is so much more that can be done, that can't
be done with the db wizards, which are not available in MS Expression Web, which is the replacement
for FP.

2. As long as the FP extensions are installed and configured correctly by the web host, then your
access database is secure and can not be access via a browser. Depending on what type of data you
storing, storing the database outside of the web root is the way to go, but this depends on your web
host.

3. How do you define slower then other database?
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[frontpagecustoms.com]

1. An Access database can handle 5000 to 6000 connections per hour depending on how ASP code was
written. You need to learn how to hand code, as there is so much more that can be done, that can't
be done with the db wizards, which are not available in MS Expression Web, which is the replacement
for FP.

2. As long as the FP extensions are installed and configured correctly by the web host, then your
access database is secure and can not be access via a browser. Depending on what type of data you
storing, storing the database outside of the web root is the way to go, but this depends on your web
host.

3. How do you define slower then other database?
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

1. What resources do you have for learning to hand code in asp? Do
you recommend learning Visual Web designer instead?

2. I am storing personal information for event registrations. What
about accessibility to hackers or people who would want to harvest the
information for spanning or malicious intent?

3. At times the website appeared sluggish when loading data pages.