Microsoft Access or SQL Server 2000

ravimeetsu
ravimeetsu used Ask the Experts™
on
Hi

I was wondering whether any body could answer the question below :

Advantages and Disadvantages of SQL Server 2000 over Microsoft Access.

That is why switch to SQL Server 2000 if MS Access answers all the needs.

Regards
Ravi
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT Engineer
Distinguished Expert 2017
Commented:
Hi Ravi,

If MS Access fullfill your needs, don't change to MS SQL Server.

For me the unique advantage of MS Access is the price.
In the rest MS SQL Server beats MS Access (speed, power, security, scalability, ...).

Best regards,


Vitor Montalvao

Commented:
I agree with vitor -

Access Pluses
$price
distribution


If you need scalability for many users and larger amounts of data - or see that coming in the near future - i would definitely migrate to SQLServer.

Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - Answered by: VMontalvao  
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
Per recommendation, force-accepted.

Netminder
EE Admin

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial