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 |
|
lkeeba
Starting Member
17 Posts |
 Posted - 2007-05-03 : 07:27:40
|
| When I access SQL2K using ODBC, I am not able to display data. The columns show #Deleted as their data values. How do I display data in ACCESS using a link to SQL2K? |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-05-03 : 08:27:49
|
| Do your SQL Server tables that you area linking to all have primary keys? That is important not only for linking in from Access, but from a database design perspective as well.- Jeffhttp://weblogs.sqlteam.com/JeffS |
 |
|
|
lkeeba
Starting Member
17 Posts |
Posted - 2007-05-04 : 05:35:15
|
| Thanks for the response. They ofcourse have primary keys and there is even a database diagram showing the relationships. I'm, though, trying to open one table, and no relationships involved. |
|
|
|
|
|
|
Accessing SQL2K using MS ACCESS