linked tables with SQLEXPRESS all show #DELETED

  • Thread starter Thread starter phil
  • Start date Start date
P

phil

I've built a database with SQLEXPRESS and all the tables are working fine.

Using Access I can connect as a 'New Project using existing data" but if I
try to create a normal Access MDB and just link to the tables using ODBC and
the SQL Server all the records appear with the cell marked as #DELETED

I can even enter records but when they are re-displayed they show as
#DELETED

Is there some setting I have missing

Many thanks for any help recieved
Phil
 
phil said:
I've built a database with SQLEXPRESS and all the tables are working fine.

Using Access I can connect as a 'New Project using existing data" but if I
try to create a normal Access MDB and just link to the tables using ODBC and
the SQL Server all the records appear with the cell marked as #DELETED

I can even enter records but when they are re-displayed they show as
#DELETED

Is there some setting I have missing

Many thanks for any help recieved
Phil
Click to expand...

This can happen if your SQL tables contain fields with a data type
that is "too big" for Access to handle.

HTH
Matthias Kläy
 
Back
Top