Powerslave — Tue, 02 Oct 2001 17:55:28 +0000

Thanks for the information.
)

Peter J. Boettcher — Mon, 01 Oct 2001 12:43:45 +0000

I guess you've figured out by now that SQL is the way to go, there's really no comparison. Access is fine for a small personal site, or for testing, but for anything else you should really use SQL.

There's some good examples of search scripts at asp101.com, in the samples section.

detox — Sun, 30 Sep 2001 14:28:29 +0000

SQL is definetely the way to go. As for scripts, what are you looking for? Aspin.com is the best place to start in my experience. It is one of the larget resources on the net for ASP.

Mark Hensler — Sun, 30 Sep 2001 06:59:10 +0000

I've not tested this personally, but I've heard from several sources that Access can't handle more than 20 connections.

MSQL

pbaugher — Sat, 29 Sep 2001 23:45:14 +0000

You'll have to use SQL for this large of a database... with Access you'll be limited to approximately 20 Data connections (at a time), SQL scales depending on the capabilities of the server it's hosted on, and is much faster and robust. Access is fine for small amounts of data - say up to 100,000 entries, anything more and you'll need SQL.

As for code samples... look around the web, many exist.

Be sure to check: aspin.com

-pb