SQL Server or Access??

[edubbelaar]

Hello colleagues,

I have a very simple, general but important question. When do you should migrate an Access database to SQL Server? What are the limitations on Access (number of records, database size, simultaneous users and transactions, ie.)?

We use a frontend/backend database application in Access 2000. The backend is around 50Mb and saves +30.000 records. Each users has its own frontend application with is linked to the same backend. All frontend’s are on the same file server as the backend.

The speed of the database is much slower now we migrated to Office 2003, even after converting the database (FE's and BE) to 2003. Our IT dept. says that a migration to SQL is the key to success...?! Is it?

Thanks in advance.


PS: Sorry for my bad English, I'm Dutch, but happy ;-)

 

[SQL_Hell]

Hello hollander


How many concurrant users do you have?

To be honest your backend is tiny (50mb), I would not think that you really need sql server currently.


You mention that the front ends are on the same file server as the backend, try putting the front end on each users machine, this should help speed up performance because at the moment you sending the forms/reports etc over the network which is not necessary.

 

[edubbelaar]

Hi SQL_Hell, thanks for your reponse.
The number of concurrent users is aprox. 3 at the same time.

Unfortnally it's not possible to copy the frontend's to the local machine of the users, because we work with Wyse Windows Terminals connected to a Windows 2003 Terminal Server (there a 3 of these servers connected via a load balancer whitch handles the connections).

I've found this document: Microsoft Access or SQL Server: What's right in your organization? Hope it would be useful.