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 |
|
skchwek4x
Starting Member
1 Post |
 Posted - 2012-01-17 : 07:28:33
|
| Hi,Please can someone help me with the following:I can't see any tables (or views) in MS Access (ODBC) when I attempt to add a NEW linked table to ONE of our SQL databases.I can successfuly link/import data via ODBC from other databases on the server (SQL 2000 SP3,NT4 SP6a).Previously linked tables in MS Access work fine, it's only new links ones which are the problem.It was working fine on the 22-Dec-11 and nothing has been knowingly changed on the server.I've tried 5 different machines (all XP) with various versions of MS Access (2000,2002,2003); all of them have the same problem.How can I see the SQL tables/views in MS Access (Get External Data, Link Tables..)?ThanksSimon |
|
|
|
|
|
No tables/views visible using ODBC