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 - 2006-05-04 : 09:03:27
|
| Siddhu writes "Defferance Between MS Access And SQL Server" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-05-04 : 09:04:59
|
MS Access often defers to SQL Server, because SQL Server is much more powerful than Access.  |
 |
|
|
mmarovic
Aged Yak Warrior
518 Posts |
Posted - 2006-05-04 : 11:07:58
|
You can access sql server from access using link tables. OTOH you can access access database from mssql server using openQuery. You can also use dts to access access db and even ssis which are both etl tools shipped with last two versions of sql server.Another difference is that sql server sql is not the same as access sql.Finally, I am quite sure sql server is server but I am not sure about access.Hope it helps.  |
|
|
|
|
|
|
SqlServer