ODBC Link to SQL 2005

  • Thread starter Thread starter Newbie
  • Start date Start date
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?
 
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).
 
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.
 
you just need to use Access DAta Projects

all this linking crap is called 'unnecessary complexity'
 
Back
Top