I dropped a table (table B) that was linked from another
(table A). Now when I try to delete a row in table A, it
throws an error saying the object could not be found.

If I recreate table B with the linked field (even if it
is empty and a different data type), then I can delete
rows from table A.

I want to get rid of table B, but cannot keep my
functionality. Any ideas what is happening here?

Thanks!
Brian Andrus

Hi Brian,

Is the problem related to Access? If so, I suggest that you post in
Access-specific newsgroup for more accurate information.

Could you post the exact steps to reproduce the problem so that I can
perform further research on my side?


Bill Cheng
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "Brian Andrus" <sysop@millenia.com>
| Sender: "Brian Andrus" <sysop@millenia.com>
| Subject: Cannot delete rows
| Date: Fri, 1 Aug 2003 22:42:48 -0700
| Lines: 13
| Message-ID: <04a501c358b8$e8252100$a501280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcNYuOgl4wzhOdBsR3GRtX3xcSF1kQ==
| Newsgroups: microsoft.public.sqlserver.odbc
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.odbc:39357
| NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| I dropped a table (table B) that was linked from another
| (table A). Now when I try to delete a row in table A, it
| throws an error saying the object could not be found.
|
| If I recreate table B with the linked field (even if it
| is empty and a different data type), then I can delete
| rows from table A.
|
| I want to get rid of table B, but cannot keep my
| functionality. Any ideas what is happening here?
|
| Thanks!
| Brian Andrus
|

"Brian Andrus" <sysop@millenia.com> wrote in message
news:04a501c358b8$e8252100$a501280a@phx.gbl...
> I dropped a table (table B) that was linked from another
> (table A). Now when I try to delete a row in table A, it
> throws an error saying the object could not be found.
>
> If I recreate table B with the linked field (even if it
> is empty and a different data type), then I can delete
> rows from table A.
>
> I want to get rid of table B, but cannot keep my
> functionality. Any ideas what is happening here?

Jet usually requires a unique index (or primary key) field on a table in
order to allow deletes, updates, etc. If one does not exist on table A,
perhaps you could create one. Also, create a column of data type timestamp,
this helps Jet determine whether the row has changed since the last update.

Steve