Upgrading from Access to mySQL

S

shikha

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
 
T

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
==============================================
 
S

shikha

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
 
T

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
==============================================
 
S

shikha

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table Security in Access 2013 1
Access, ASP and PHP, MySQL confussion 6
Access for MySQL data reports only 5
Access to Mysql 1
Post marked text from Word file to MySQL 0
access, mysql and web page 0
Sending email from Access or MySQL address list 2
Visio reverse engineering of MYSQL database does not see views 0

Top