Guys my company has agreed to purchase SQL Server 2000 using one processor for an app i'm creating. this i hear is better than using MS Access.

Here are a few questions.

1) Does SQL Server Standard Edition only allow for 10 simultaneous users?

2) Is programming using ADO different from using MS Access? I have no experience with SQL Server and I will be doing all the work myself.

3) Will setting up the database be different from the basics I'm used to with MS Access? I will have to create the normalized database myself.

4) Can i install the software on my workstation to test before goign live?

Thanks guys. I hope this isn't taht difficult. I'm trying to reduce the learning curve as much as possible but hope to be able to expand my learning as time goes on.