Frontpage 2000 - change of database - advice please

Hi

I'm happy working with Access 2000 but I want to start a new site
which might generate more than 50 concurrent hits.

I have read somewhere that for more than 50 database hits you need
to migrate to MYSQL.

Can anyone explain how you do this through FP2000.
And does the SQL that Access generate have to be altered in anyway.

Thank you in advance - Stephen

You can upsize your Access database to SQL. See:
http://support.microsoft.com/defaul...kb;en-us;241743
http://support.microsoft.com/defaul...kb;en-us;244309

Your host must support SQL on your server and you must have the proper
permissions. MySQL is a different database (usually run on UNIX) than SQL
(Windows).
HTH

--
Theresa Bennett
http://webworksite.com
"The worksite for designers and developers."
Play "Where's Web Guy?" and get some free goodies!
===================================================

FrontPage 2000 Search the Knowledge Base
http://support.microsoft.com/defaul...fh;EN-US;fp2000
FrontPage 2002 Search the Knowledge Base
http://support.microsoft.com/defaul...fh;EN-US;fp2002

"Stephen" <gilly@knight04july.fsworld.co.uk> wrote in message
news:bgo39n$t4t$1@news8.svr.pol.co.uk...
> Hi
>
> I'm happy working with Access 2000 but I want to start a new site
> which might generate more than 50 concurrent hits.
>
> I have read somewhere that for more than 50 database hits you need
> to migrate to MYSQL.
>
> Can anyone explain how you do this through FP2000.
> And does the SQL that Access generate have to be altered in anyway.
>
> Thank you in advance - Stephen
>
>

FWIW,

I uses FP 2002 and Access to create corporate intranets
with alot of database integration and more than 50 hits
at once (depending on data required) and have had no
problems with the database or records.

HTH

-M
>-----Original Message-----
>Hi
>
>I'm happy working with Access 2000 but I want to start a
new site
>which might generate more than 50 concurrent hits.
>
>I have read somewhere that for more than 50 database
hits you need
>to migrate to MYSQL.
>
>Can anyone explain how you do this through FP2000.
>And does the SQL that Access generate have to be altered
in anyway.
>
>Thank you in advance - Stephen
>
>
>.
>

Thank you Michael - I think I will stick with Access and see how it goes.

I have just downloaded PHP (which apparently you need if you use MySQL)
saw what was involved and immediately removed it - I just can't handle
learning another package!

Thanks, Stephen


"Michael Stumpo" <mstumpo@paralleledge.com> wrote in message
news:0c0201c35b54$b55123c0$a401280a@phx.gbl...
> FWIW,
>
> I uses FP 2002 and Access to create corporate intranets
> with alot of database integration and more than 50 hits
> at once (depending on data required) and have had no
> problems with the database or records.
>
> HTH
>
> -M
> >-----Original Message-----
> >Hi
> >
> >I'm happy working with Access 2000 but I want to start a
> new site
> >which might generate more than 50 concurrent hits.
> >
> >I have read somewhere that for more than 50 database
> hits you need
> >to migrate to MYSQL.
> >
> >Can anyone explain how you do this through FP2000.
> >And does the SQL that Access generate have to be altered
> in anyway.
> >
> >Thank you in advance - Stephen
> >
> >
> >.
> >

Access will work just fine for you, and can handle a lot more then that.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Stephen" <gilly@knight04july.fsworld.co.uk> wrote in message
news:bgo39n$t4t$1@news8.svr.pol.co.uk...
> Hi
>
> I'm happy working with Access 2000 but I want to start a new site
> which might generate more than 50 concurrent hits.
>
> I have read somewhere that for more than 50 database hits you need
> to migrate to MYSQL.
>
> Can anyone explain how you do this through FP2000.
> And does the SQL that Access generate have to be altered in anyway.
>
> Thank you in advance - Stephen
>
>