Handling more traffic

[ryanwallace]

I run a website that is stretching the limits of my current infrastructure.

That infrastructure is:
Server: Hostway.com Dedicated Windows Server
Database: multiple Access databases
Page type: ASP
Connection type: VBscript (coded with Adobe GoLive 6.0)

I am not a code guy and am limited by what I can do with a graphical program (Adobe GoLive 6.0 or Dreamweaver). Currently I use Golive to create the connection to the Access database (which is located a special folder created by GoLive) and then use GoLive to bind the fields of the database to my template ASP page.

The problem: Right now on high traffic days I am getting a "Jet database error" which I understand to be an overload of the Access database.

A possible solution?: I have Microsoft® SQL Server 2000 installed on my dedicated server. Can I somehow use this to expand the capabilities of my Access database? How does this SQL server work? Do I need a different database authoring software to take advantage of the SQL server?

I am open to differnt database types and connection metods (assuming I can perform them in GoLive or Dreamweaver)

I would greatly appreciate any assistance/advice that anyone can offer. I'm pretty good at figuring this stuff out, but I need to be pointed in the right direction.

Thank you in advance!

[PeOfEo]

access cuts off at 10 users updateing at a time. SQL server will run faster and more efficient, you will not need any new software. You can do remote access to the data base from regular msaccess, so you can still create all of your tables in your data base and all.

[ryanwallace]

Thank you PeofEo!
Now my next questions are:
A.How do I use MS Access to create and modify tables on SQL server?

B. How do I refer to the SQL server database in my GoLive interface? I have the option of creating a UDL file which can point to a database located anywhere.

Thank you all again for your help with this. I know my simple question might be a little exasperating.

[buntine]

A.How do I use MS Access to create and modify tables on SQL server?


This is quite simple to do once you get past the learning curve. Rather than posting a bunch of code, i think the wisest thing to do is check out one of the following web sites which go into detail about how to use database connectivity in your ASP pages.

www.w3schools.com
www.asp101.com
www.4guysfromrolla.com

In order to successfully open/modify/remove/add records to an access database, you will need a basic knowledge of the following technologies.

ADO - ActiveX Data Objects
SQL - Structured Query Language
ASP - Active Server Pages (of coarse)

Regards,
Andrew Buntine.

[PeOfEo]

Originally posted by ryanwallace
Thank you PeofEo!
Now my next questions are:
A.How do I use MS Access to create and modify tables on SQL server?

B. How do I refer to the SQL server database in my GoLive interface? I have the option of creating a UDL file which can point to a database located anywhere.

Thank you all again for your help with this. I know my simple question might be a little exasperating. project existing data, and project new data. Put in the server url, port, pass, username, all that good stuff.