If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#Deleted field values in a linked table
I am connecting via ODBC to a number of tables in a database, located on an
SQL server. One of the tables that I’m linking to is a table that is updated automatically via DTS with the update kicked off by a VB script. On the Access side, if I view this table all I see are #Deleted flags in all fields, even though there is data in the table if I view it from SQL Enterprise Manager. All other ODBC linked tables display data correctly. If done a refresh links in Access, removed and reestablished the link to the table, and that has not rectified the problem. If I run a query, report, or view the table through a form in Access all I get is #Deleted. However, if I export this table from Access to Excel I get all of my records exported. Anyone out there encounter this problem before, or is there something I’ve overlooked? Thanks ahead of time. -- Kevin Backmann |
#2
|
|||
|
|||
#Deleted field values in a linked table
Using a bigint field as the primary key in SQL Server will do this, but
there are other possible causes too. Check out some of the articles in the list at the following URL ... http://search.msdn.microsoft.com/sea...d+%23De leted -- Brendan Reynolds Access MVP "Kevin B" wrote in message ... I am connecting via ODBC to a number of tables in a database, located on an SQL server. One of the tables that I'm linking to is a table that is updated automatically via DTS with the update kicked off by a VB script. On the Access side, if I view this table all I see are #Deleted flags in all fields, even though there is data in the table if I view it from SQL Enterprise Manager. All other ODBC linked tables display data correctly. If done a refresh links in Access, removed and reestablished the link to the table, and that has not rectified the problem. If I run a query, report, or view the table through a form in Access all I get is #Deleted. However, if I export this table from Access to Excel I get all of my records exported. Anyone out there encounter this problem before, or is there something I've overlooked? Thanks ahead of time. -- Kevin Backmann |
#3
|
|||
|
|||
#Deleted field values in a linked table
Thanks for the reply. I guess I've got some reading to do, but that's what
lunch break is for, I suppose. I'll leave a reply in this thread as to what the cause was, just in case you're interested. Thanks again... -- Kevin Backmann "Brendan Reynolds" wrote: Using a bigint field as the primary key in SQL Server will do this, but there are other possible causes too. Check out some of the articles in the list at the following URL ... http://search.msdn.microsoft.com/sea...d+%23De leted -- Brendan Reynolds Access MVP "Kevin B" wrote in message ... I am connecting via ODBC to a number of tables in a database, located on an SQL server. One of the tables that I'm linking to is a table that is updated automatically via DTS with the update kicked off by a VB script. On the Access side, if I view this table all I see are #Deleted flags in all fields, even though there is data in the table if I view it from SQL Enterprise Manager. All other ODBC linked tables display data correctly. If done a refresh links in Access, removed and reestablished the link to the table, and that has not rectified the problem. If I run a query, report, or view the table through a form in Access all I get is #Deleted. However, if I export this table from Access to Excel I get all of my records exported. Anyone out there encounter this problem before, or is there something I've overlooked? Thanks ahead of time. -- Kevin Backmann |
#4
|
|||
|
|||
#Deleted field values in a linked table
The culprit was a BigInt field type that is used in a clustered index.
Thanks again Brendan... -- Kevin Backmann "Kevin B" wrote: I am connecting via ODBC to a number of tables in a database, located on an SQL server. One of the tables that I’m linking to is a table that is updated automatically via DTS with the update kicked off by a VB script. On the Access side, if I view this table all I see are #Deleted flags in all fields, even though there is data in the table if I view it from SQL Enterprise Manager. All other ODBC linked tables display data correctly. If done a refresh links in Access, removed and reestablished the link to the table, and that has not rectified the problem. If I run a query, report, or view the table through a form in Access all I get is #Deleted. However, if I export this table from Access to Excel I get all of my records exported. Anyone out there encounter this problem before, or is there something I’ve overlooked? Thanks ahead of time. -- Kevin Backmann |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query is not updatable - | Doug Johnson via AccessMonster.com | Running & Setting Up Queries | 3 | January 21st, 2006 12:36 AM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
Update - If statement | Dan @BCBS | Running & Setting Up Queries | 13 | December 14th, 2004 06:02 PM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |