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 |
|
jhermiz
3564 Posts |
 Posted - 2008-05-22 : 10:15:16
|
| I had to create a linked table from SQL Server to an access application for someone in the company. I simply created an ODBC connection to that db->table and was able to add it to their access 2003 db. So they were able to access the sql table.I had done this via a system dsn.Now someone else wanted the same thing but they were running access 2007. I tried to open that same table but got an error. So I figured all I had to do was create an ODBC on that machine as well. I did that and all worked well...so that machine was fine.Within an hour I got a call from the user who uses the Access 2003 machine stating now when they try to open the linked table it was giving them an ODBC connection error.Does anyone know if there is any compatibility issues with having done it on a vista machine running office 2k7 versus running it on windows xp with access 2k3 ?Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-22 : 10:43:54
|
Is the linked table in exclusive mode?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
linked table issues