Linking to SQL Server 2005 from Access 2003
Posted on 2007-07-26
For the first time, I am trying to link tables from a SQL Server 2005 database into Microsoft Access 2003. Everything looks good when I create the ODBC connection, then I link the tables, which also appears to work. When I open the table however, Access is aware of the table structure because the column headings appear, but the data is missing - instead I have only the Access !deleted! in every row and column.
Anyone know why?