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-14 : 02:49:38
|
| I looked at it from all sides I could imagine: I have not been able to link an SqlServer VIEW to an Access mdb database.Is that by design? And is there no workaround at all?Or did I miss something?At least I can't see a reason why this should not possible, in principle.Thanks to tell me if you know about that. |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2008-01-14 : 08:14:23
|
| I've done this with Access 97 and SQL Server 7 and 2000 (and if memory serves I have done the same with Access 2000/XP too). It's just the same as linking a table. Which versions of SQL/Access are you using, how are you linking? Is it via ODBC? What errors are you getting? Can you see other objects in the database?steve-----------Don't worry head. The computer will do all the thinking from now on. |
 |
|
|
lalbatros
Yak Posting Veteran
69 Posts |
Posted - 2008-01-14 : 16:23:28
|
| I am using Access 2003 and SQL server 2000.Seems it is working now, using the File menu, simply.Maybe I started working too early ...Thanks anyway. |
|
|
|
|
|
|
Linking an Access mdb to an SqlServer VIEW