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-14 : 15:25:01
|
I havent done access in quite some time but I was trying to link a 2005 SQL Server table to an access db. I created the odbc connection and can link the table but upon opening the table in MS Access all I see is #Deleted for values in all the fields. Something to this effect: Anyone know why this happens? Or how I can see the actual data?Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
jhermiz
3564 Posts |
Posted - 2008-05-15 : 13:19:27
|
quote:
Originally posted by jsmith8858
Does the table you are linking to have a primary key defined? If not, Access cannot browse the data since it has no way of knowing which row you are on.see:http://support.microsoft.com/kb/128809- Jeffhttp://weblogs.sqlteam.com/JeffS
Sorry forgot to post the answer. I read somewhere that access does not like the bigint style columns for PK...once it was converted to INT it worked fine.JonWeblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
|
|
|
Linked SQL 2005 table to access