access and sql2000/5

Hello
I would like to clarify in my mind several points regarding MS databases
What is the main difference between ms access and sql 2000 -2005.
What is the difference between visual studio and sql 2000/5
Can sql 2000/5 be used with classic asp
Thanks
John
johnhardyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Goodangel MatopeSoftware ArchitectCommented:
MS Access is a desktop database, intended for small applications which work on desktop PCs. MS SQL Server is an enterprise level database that can work on a server with hundreds, of users if necessary. The main differences are that MS Access has a 2GB size limit, and SQL Server is limited only by your hardware. SQL Server has user logins, user level access, backup and restore functionality, programability features like stored procedures.

Yes, SQL Server can be used with classic ASP.

check this link out these links

http://forums.devarticles.com/microsoft-access-development-49/difference-between-access-and-sql-server-11278.html

http://sqlserver2000.databases.aspfaq.com/what-are-the-main-differences-between-access-and-sql-server.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
johnhardyAuthor Commented:
Thanks thats making this much clearer

Can you please comment on this
What is the difference between visual studio and sql 2000/5
0
mcmonapCommented:
Hi johnhardy,

Visual Studio is an application IDE (Integrated Development Environment) for MS programming languages such as Visual Basic, C++, ASP and many others, SQL server is as described by Goodangel.  They are two entirely different applications - at a basic level (from a DBA perspective) databases are there to store and manage data and applications (written in visual Studio) are there to provide access to the data and make it look pretty for end users.
0
johnhardyAuthor Commented:
Thank you both very much
John
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.