Linked SQL-Server data not visible (imported data fine)

[maggiethomas]

I set up two linked tables from my SQL database, and ran a query. I get the
correct number of columns and rows appearing in the results, but the values
are all set to '#Deleted'.

I then imported the two tables, ran the same query - and it worked fine, I
got the expected values in the results.

I need to link as the SQL database is updated many times a day, and I report
on the current state of play many times a day. Taking a snapshot each time
is not very practical.

Sorry if this is a very basic question!
Thanks,
Maggie

 

[phillips001]

This will occur as you described if one or both of the tables have an
identity defined as bigint. Only an import or a query property change (every
time) to snapshot will avoid this. Bigint as a key value is not supported in
MS Access. If you're really trying to access a table that has a gazillion
records in it, you should probably use something else other than Access,
otherwise it's your DBA's mistake for setting it up that way. Since you
actually can import the tables into Access, then I suspect your DBA is at
fault and your basic question is quite valid.

 

[BigHair101]

I have this same issue. You said I should use something other than Access.
What do you suggest?

Thanks.