Access 2007 Linked tables with SQL server 2008 not showing data

G

Greg

I haven't worked with Access for years. Now, I have a front end the client
wants in Access 2007. The backend is SQL Server 2008. I created an Access
2007 DB and linked the tables from the SQL Server DB to it. The smaller
tables show all of the data when I open them in Access; but, some of my
larger tables don't. The columns all have the value of #DELETED in them.
What's happening here? Thanks in adance for any and all guidance and help
here.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked SQL Tables don't report Cascading Updates and Deletes 2
Best way to deploy Access read-only database that is linked to SQL tables 6
Access 2007 and connecting to SQL server 2008 6
SQL Server Backend is Read Only 7
SQL Server Backend: linked tables or no more bound forms ? 4
linking from access to SQL tables 4
connecting to sql server 2008 from access 2002 1
Access and SQL Server 4

Top