What i would like is some information about a access database.

How many members can one hold?
How would an access database stand with a site receiving 10,000+ hits a day?
How many members can a access database with stand? I.E would the database stand the preasure of 100+ members logged in at the same time?

How difficult would it be to transfer an asp script (site) from a access database to a mssql database?

Thanks any info welcome.

Hello,

Thanks for the link very helpfull!

I was looking at instructions on converting the access database to a mssql database and was going to give this a go.

the script i am using has 3 files called xxx.asp that connects to the database 1 in the main root 1 in the members folder and 1 in the admin folder if the conversion from access to mssql are these 3 files the only files that need to be edited to conect to the database or would any other files need to be edited.

My site is here http://www.scspromotions.com - http://www.scspromotions.com

ADDED!!!!

I followed the instructions to convert the database to mssql and from what i can see everything went fine.

I eddit the 3 files to connect to the database but certain pages are giving errors all errors are pointing to a line off code that says:

conn. close

Any ideas what im doing wrong?

Main page: neer bottom:

http://www.scspromotions.com - http://www.scspromotions.com

Microsoft VBScript runtime error '800a01a8'

Object required: 'Provider=SQLOLEDB;Se'

/default.asp, line 476

Sign Up Page:

http://www.scspromotions.com/signup.asp - http://www.scspromotions.com/signup.asp

Microsoft VBScript runtime error '800a01a8'

Object required: 'conn'

/signup.asp, line 114

Every error is the same and the error points to a line off code thst says:
conn.close

When i remove that line of code the error goes away and everything seems to work fine (should i remove that code from each file? what does conn.close mean?)