ODBC Link to SQL 2005

N

Newbie

I am trying to link table to Access 2003 from SQL 2005

Some tables come across ok but others just have the word deleted in all the
fields

Any ideas?
 
S

Sylvain Lafontaine

Maybe these table have a missing primary key or you using a type of field -
such as BIGINT - which is incompatible with Access. Nullable bit value (Bit
field without a default value and that can be set to Null) and some out of
range precision for decimal/currency type can also be troublesome.

You should make a copy of these tables and start removing the fields until
you find the offensive one(s).
 
P

phillips001

Hi, I needed to figure this out too. Evidently, use of bigint (or other
floating) used as a key will not produce an updateable link. In access, you
probably don't want to anyway, but it would be nice to see the data instead
of #Delete splattered all over the screen. My solution: Set up a query
(simple select *), and change the Recordset Type property to Snapshot. Use
this snapshot query as a source to any subsequent work.
 
T

Tom Wickerath

you just need to use Access DAta Projects

all this linking crap is called 'unnecessary complexity'
 
Top