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 |
|
lalbatros
Yak Posting Veteran
69 Posts |
 Posted - 2008-01-18 : 16:35:00
|
| I have been looking to link and access mdb to some sys-tables on an sql-server.I have been surprised to see that only 2 of the 19 sys tables in my database were available for a link.I would like to understand why it is so.And I would like to know if the other 17 tables could be linker to by other means that using the acces menus, like by writing a few VB lines for doing that. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-20 : 00:41:33
|
| You can access them with vb script if you have proper permission. |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-01-21 : 00:06:02
|
| You could create a view on the system tables you want and link to those.CODO ERGO SUM |
|
|
|
|
|
|
MSAccess: linking to sqlserver sys tables