Skip to main content
Inspiring
December 15, 2008
Question

Access to SQL server

  • December 15, 2008
  • 1 reply
  • 225 views
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.
This topic has been closed for replies.

1 reply

Inspiring
February 5, 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.
>