Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-10 : 08:31:37
|
| Venkat writes "Is there a document/article that would compare features of MSAcess and SqlServer2000?Thx" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-01-10 : 09:45:33
|
| Well, to me, that's kinda like asking for a comparison of Excel vs. Access. Or kinda like comparing a Vespa Scooter vs. a Hayabusa. Or like comparing a Phillies Blunt vs. a Partagas Series D No. 4. Or like Cuervo vs. Patron. Or like CR-V vs. Range Rover....similar, but different tools for different jobs... It's kinda tought to compare with such minimal common ground. Yeah, they are both sold as 'databases'. Yeah, they both use some dialect of SQL to access data. I can't think of too much else.Maybe you could start here:http://www.google.com/search?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=ms+access+vs+sql+server&btnG=Google+SearchJay White{0} |
 |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-01-10 : 12:26:53
|
| Perhaps the most important thing to know is that SQL Server is purely a back-end database. ie. it stores data in tables and allows you to query the data but NOT present it with a nice user interface (UI). Access also allows you to design a UI for presenting the data.You could for example use SQL Server to hold and query the data and use access to design the screens to present the data to the user.As Jay says though surf the net for the deeper differences as there are plenty.===========Paul |
|
|
|
|
|
|
Compare MSAccess and SqlServer 2000