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 - 2005-12-13 : 07:37:29
|
| RD writes "Do you have a comparative article on SQL Express and MS Access?" |
|
|
activecrypt
Posting Yak Master
165 Posts |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-12-15 : 01:31:28
|
| Hi,A more appropriate comparison is Express versus Jet since they are both database engines and Access is an application development environment. Either way, no such paper exists for Express. There are a number of papers that discuss the difference between MSDE and Jet and give tips for using MSDE as a data store for either Access or VB applications. These seem to be the ones to start with:Using Microsoft Access 2002 with MSDE 2000Pasted from <http://msdn.microsoft.com/library/en-us/dnacc2k2/html/odc_msdeintro.asp?frame=true> Appropriate Uses of MSDE FAQPasted from <http://www.microsoft.com/sql/msde/howtobuy/msdeuse.mspx> Choosing and Using MSDE 2000 as the Database Engine for Your ApplicationPasted from <http://msdn.microsoft.com/library/en-us/dnmsde/html/msderoadmap.asp?frame=true> Microsoft Data Engine (MSDE) for Microsoft Visual Studio 6.0: An Alternative to Jet for Building Desktop and Shared SolutionsPasted from <http://msdn.microsoft.com/library/en-us/dnmsde/html/msdeforvs.asp?frame=true> Hope these help,Regards.Paul RandalLead Program Manager, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
|
|
|
Comparative article on SQL Express and MS Access