A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

#Deleted field values in a linked table



 
 
Thread Tools Display Modes
  #1  
Old February 22nd, 2006, 05:46 PM posted to microsoft.public.access
external usenet poster
 
Posts: n/a
Default #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  
Old February 22nd, 2006, 06:07 PM posted to microsoft.public.access
external usenet poster
 
Posts: n/a
Default #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  
Old February 22nd, 2006, 06:17 PM posted to microsoft.public.access
external usenet poster
 
Posts: n/a
Default #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  
Old February 22nd, 2006, 08:15 PM posted to microsoft.public.access
external usenet poster
 
Posts: n/a
Default #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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 01: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 07:02 PM
COMPARE THE TWO TABLES Stefanie General Discussion 0 June 4th, 2004 04:36 PM


All times are GMT +1. The time now is 10:35 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.