Upgrading from Access to mySQL

[Guest]

Hi,

I am currently running a website using Access, and in the real world access
can support anywhere from 25-50 users. The website will be used by 70
customers, so it is the time to upgrade the database.

I was looking at the option of mySQL, and the webhost does support it. I am
really not sure what I have to do, to start the process. I called webhosting
and they said I will be publishing mySQL database just like I do with Access.

Concern that I have is, is it easily compatible with Frontpage using ASP?
Do I just download mySQL and created table, and should be that simple?

Any help will be grealty appreciated

Thanks,

Shikha

 

[Thomas A. Rowe]

In the real world, Access can support 6,000+ users per hour depending on how the site is coded.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

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

 

[Guest]

Hi Thomas,

Well my site should be expecting about 70 customers...so will access be able
to hold 70 queries to database simultaneously, without being very slow?

I really don't want to upgrade, f it is a reasonable solution. When you
say, depending upon how your site is coded..what exactly you mean? Sorry, I
am bit confused about that.. Because if anything i can do from the coding
side to make it more effficient, I am all up for it.

Thanks!!!!

Shikha

 

[Thomas A. Rowe]

Yes, you will have no problem with 70 users.

How the site is coded, means mainly not use the FP database components, learn to hand code and open
the database connection once, and then open and close each table in the database as needed, etc.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

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

 

[Guest]

Thomas,

Thank you so much for your help. Currently I am using FP database
components, but slowly I can learn how how to hand code...

Once again thank you for your quick reply

Shikha