Access to SQL server

Report · Dec 15, 2008

Hi,

I am now developing a site/CRM based on MS Access. It's all great, but the database is filling up fast.
Now I have an access database of 6MB. (1500 clients). I want to add another region to it (another 1500 clients) and all visits from now on will be stored also in the database.
Now one user, but if all goes alright maybe up to 10 users.

When should I switch to a SQL server database (or something else?) Server Side language is ASP with VBScript on IIS / 2003 Server.

Thanks.

Report · Feb 05, 2009

Three reasons we need to migrate to SQL Server:

1.) Customers complain about performance
2.) Customers complain about performance
3.) Customers complain about performance

"PaulTest" <webforumsuser@macromedia.com> wrote in message
news:gi5620$sdo$1@forums.macromedia.com...
> Hi,
>
> I am now developing a site/CRM based on MS Access. It's all great, but the
> database is filling up fast.
> Now I have an access database of 6MB. (1500 clients). I want to add
> another
> region to it (another 1500 clients) and all visits from now on will be
> stored
> also in the database.
> Now one user, but if all goes alright maybe up to 10 users.
>
> When should I switch to a SQL server database (or something else?) Server
> Side
> language is ASP with VBScript on IIS / 2003 Server.
>
> Thanks.
>