We deleted a record and it involved an associated record and we can no longer
open our table. Can we undo the deletion?

You can no longer open the table? What error do you get?


--
Rick B



"CANS" <(E-Mail Removed)> wrote in message
news:B142E8CF-3293-4F48-8221-(E-Mail Removed)...
> We deleted a record and it involved an associated record and we can no
> longer
> open our table. Can we undo the deletion?

We get "Record is deleted" which is error 3167 I believe.

D.

"Rick B" wrote:

> You can no longer open the table? What error do you get?
>
>
> --
> Rick B
>
>
>
> "CANS" <(E-Mail Removed)> wrote in message
> news:B142E8CF-3293-4F48-8221-(E-Mail Removed)...
> > We deleted a record and it involved an associated record and we can no
> > longer
> > open our table. Can we undo the deletion?
>
>
>

You are trying to open a TABLE and you get an error saying RECORD is
deleted?

That makes no sense. You are in the database window and you try to double
click a table and it won't open?

--
Rick B



"CANS" <(E-Mail Removed)> wrote in message
news:141A936E-1694-4ACA-BA17-(E-Mail Removed)...
> We get "Record is deleted" which is error 3167 I believe.
>
> D.
>
> "Rick B" wrote:
>
>> You can no longer open the table? What error do you get?
>>
>>
>> --
>> Rick B
>>
>>
>>
>> "CANS" <(E-Mail Removed)> wrote in message
>> news:B142E8CF-3293-4F48-8221-(E-Mail Removed)...
>> > We deleted a record and it involved an associated record and we can no
>> > longer
>> > open our table. Can we undo the deletion?
>>
>>
>>

We had two records with errors in them. We deleted them because we couldn't
get the table to sort. Once we did and closed the table we now get, "Record
iis deleted" and "Can't open in Datasheet view." errors and the table will
not open. We tried deleting relationships with the other table we have and
still no access. We can get into the design view but not to the data itself.
Very frustrating.

Anything you can suggest would be helpful.

D.

"Rick B" wrote:

> You are trying to open a TABLE and you get an error saying RECORD is
> deleted?
>
> That makes no sense. You are in the database window and you try to double
> click a table and it won't open?
>
> --
> Rick B
>
>
>
> "CANS" <(E-Mail Removed)> wrote in message
> news:141A936E-1694-4ACA-BA17-(E-Mail Removed)...
> > We get "Record is deleted" which is error 3167 I believe.
> >
> > D.
> >
> > "Rick B" wrote:
> >
> >> You can no longer open the table? What error do you get?
> >>
> >>
> >> --
> >> Rick B
> >>
> >>
> >>
> >> "CANS" <(E-Mail Removed)> wrote in message
> >> news:B142E8CF-3293-4F48-8221-(E-Mail Removed)...
> >> > We deleted a record and it involved an associated record and we can no
> >> > longer
> >> > open our table. Can we undo the deletion?
> >>
> >>
> >>
>
>
>

I just got word from another sourse to go to Tools->Database
Utilities->Compact and Repair Database. I didn't know I could do this.

All fixed now.

D.

"Rick B" wrote:

> You are trying to open a TABLE and you get an error saying RECORD is
> deleted?
>
> That makes no sense. You are in the database window and you try to double
> click a table and it won't open?
>
> --
> Rick B
>
>
>
> "CANS" <(E-Mail Removed)> wrote in message
> news:141A936E-1694-4ACA-BA17-(E-Mail Removed)...
> > We get "Record is deleted" which is error 3167 I believe.
> >
> > D.
> >
> > "Rick B" wrote:
> >
> >> You can no longer open the table? What error do you get?
> >>
> >>
> >> --
> >> Rick B
> >>
> >>
> >>
> >> "CANS" <(E-Mail Removed)> wrote in message
> >> news:B142E8CF-3293-4F48-8221-(E-Mail Removed)...
> >> > We deleted a record and it involved an associated record and we can no
> >> > longer
> >> > open our table. Can we undo the deletion?
> >>
> >>
> >>
>
>
>