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 |
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 |