|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
I deleted a record from a table, closed the table and on reopening it found
that the record came up as "#deleted". I deleted all relationships with other
tables and eventaully deleted the other tables. Still #deleted displayed in
all the controls for the allegedly deleted record. Please help!
|
|
Try doing a Compact and Repair Database from menu TOOLS- Database Utilities.
"N[ at ]HUedu" wrote:
[Quoted Text] > I deleted a record from a table, closed the table and on reopening it found
> that the record came up as "#deleted". I deleted all relationships with other
> tables and eventaully deleted the other tables. Still #deleted displayed in
> all the controls for the allegedly deleted record. Please help!
|
|
Is this a linked table? If it is, what kind of database is it linked to?
You probably could have cleared it by closing Access and re-opening it. But
you shouldn't have to do this at all. Something is keeping your table from
refreshing. Does the table have a unique index on it?
--
Bill Mosca, MS Access MVP
"N[ at ]HUedu" <N[ at ]HUedu[ at ]discussions.microsoft.com> wrote in message
news:EB2F585E-E7A7-4DD7-8886-3CD5BD8BEB47[ at ]microsoft.com...
[Quoted Text] >I deleted a record from a table, closed the table and on reopening it found
> that the record came up as "#deleted". I deleted all relationships with
> other
> tables and eventaully deleted the other tables. Still #deleted displayed
> in
> all the controls for the allegedly deleted record. Please help!
|
|
Thanks for your reply. The table used to be linked but I made sure I deleted
the link via "relationships". So,the table isn't linked and I did not use the
Primary key or any unique index because most of my fields can be duplicated.
"Bill Mosca, MS Access MVP" wrote:
[Quoted Text] > Is this a linked table? If it is, what kind of database is it linked to?
>
> You probably could have cleared it by closing Access and re-opening it. But
> you shouldn't have to do this at all. Something is keeping your table from
> refreshing. Does the table have a unique index on it?
>
> --
> Bill Mosca, MS Access MVP
>
>
> "N[ at ]HUedu" <N[ at ]HUedu[ at ]discussions.microsoft.com> wrote in message
> news:EB2F585E-E7A7-4DD7-8886-3CD5BD8BEB47[ at ]microsoft.com...
> >I deleted a record from a table, closed the table and on reopening it found
> > that the record came up as "#deleted". I deleted all relationships with
> > other
> > tables and eventaully deleted the other tables. Still #deleted displayed
> > in
> > all the controls for the allegedly deleted record. Please help!
>
>
>
|
|
Thanks for your reply. That sounds drastic but at this point I could try
anything. Besides, I could back up the database before I do it.
"KARL DEWEY" wrote:
[Quoted Text] > Try doing a Compact and Repair Database from menu TOOLS- Database Utilities.
>
> "N[ at ]HUedu" wrote:
>
> > I deleted a record from a table, closed the table and on reopening it found
> > that the record came up as "#deleted". I deleted all relationships with other
> > tables and eventaully deleted the other tables. Still #deleted displayed in
> > all the controls for the allegedly deleted record. Please help!
|
|
You have misunderstood the term "linked". A linked table is one that i snot
in the database. It is in another database. If the table resides in your
database, the DELETED in the field could well mean that your index on the
table is bad. Remove all indexes on that table and compact the database.
Then create the indexes again. Hopefully, that will fix the problem.
I read your response to Karl. There is nothing drastic about compacting your
database. In fact it should be done routinely.
--
Bill Mosca, MS Access MVP
"N[ at ]HUedu" <NHUedu[ at ]discussions.microsoft.com> wrote in message
news:9B093243-4614-4093-B34C-FAF0E40510F7[ at ]microsoft.com...
[Quoted Text] > Thanks for your reply. The table used to be linked but I made sure I
> deleted
> the link via "relationships". So,the table isn't linked and I did not use
> the
> Primary key or any unique index because most of my fields can be
> duplicated.
>
> "Bill Mosca, MS Access MVP" wrote:
>
>> Is this a linked table? If it is, what kind of database is it linked to?
>>
>> You probably could have cleared it by closing Access and re-opening it.
>> But
>> you shouldn't have to do this at all. Something is keeping your table
>> from
>> refreshing. Does the table have a unique index on it?
>>
>> --
>> Bill Mosca, MS Access MVP
>>
>>
>> "N[ at ]HUedu" <N[ at ]HUedu[ at ]discussions.microsoft.com> wrote in message
>> news:EB2F585E-E7A7-4DD7-8886-3CD5BD8BEB47[ at ]microsoft.com...
>> >I deleted a record from a table, closed the table and on reopening it
>> >found
>> > that the record came up as "#deleted". I deleted all relationships with
>> > other
>> > tables and eventaully deleted the other tables. Still #deleted
>> > displayed
>> > in
>> > all the controls for the allegedly deleted record. Please help!
>>
>>
>>
|
|
N[ at ]HUedu wrote:
[Quoted Text] > Thanks for your reply. That sounds drastic but at this point I could
> try anything. Besides, I could back up the database before I do it.
Drastic??? That is a standard maintenance function.
>
> "KARL DEWEY" wrote:
>
>> Try doing a Compact and Repair Database from menu TOOLS- Database
>> Utilities.
>>
>> "N[ at ]HUedu" wrote:
>>
>>> I deleted a record from a table, closed the table and on reopening
>>> it found that the record came up as "#deleted". I deleted all
>>> relationships with other tables and eventaully deleted the other
>>> tables. Still #deleted displayed in all the controls for the
>>> allegedly deleted record. Please help!
--
Joseph Meehan
Dia duit
|
|
Oh, I didn't know that. Well, I compacted & repaired it and it looks like the
problem is resolved. Thanks!
"Joseph Meehan" wrote:
[Quoted Text] > N[ at ]HUedu wrote:
> > Thanks for your reply. That sounds drastic but at this point I could
> > try anything. Besides, I could back up the database before I do it.
>
> Drastic??? That is a standard maintenance function.
>
>
> >
> > "KARL DEWEY" wrote:
> >
> >> Try doing a Compact and Repair Database from menu TOOLS- Database
> >> Utilities.
> >>
> >> "N[ at ]HUedu" wrote:
> >>
> >>> I deleted a record from a table, closed the table and on reopening
> >>> it found that the record came up as "#deleted". I deleted all
> >>> relationships with other tables and eventaully deleted the other
> >>> tables. Still #deleted displayed in all the controls for the
> >>> allegedly deleted record. Please help!
>
>
>
> --
> Joseph Meehan
>
> Dia duit
>
>
>
|
|
Thanks Bill. The compact & repair worked! How often should it be done?
"Bill Mosca, MS Access MVP" wrote:
[Quoted Text] > You have misunderstood the term "linked". A linked table is one that i snot
> in the database. It is in another database. If the table resides in your
> database, the DELETED in the field could well mean that your index on the
> table is bad. Remove all indexes on that table and compact the database.
> Then create the indexes again. Hopefully, that will fix the problem.
>
> I read your response to Karl. There is nothing drastic about compacting your
> database. In fact it should be done routinely.
>
> --
> Bill Mosca, MS Access MVP
>
>
> "N[ at ]HUedu" <NHUedu[ at ]discussions.microsoft.com> wrote in message
> news:9B093243-4614-4093-B34C-FAF0E40510F7[ at ]microsoft.com...
> > Thanks for your reply. The table used to be linked but I made sure I
> > deleted
> > the link via "relationships". So,the table isn't linked and I did not use
> > the
> > Primary key or any unique index because most of my fields can be
> > duplicated.
> >
> > "Bill Mosca, MS Access MVP" wrote:
> >
> >> Is this a linked table? If it is, what kind of database is it linked to?
> >>
> >> You probably could have cleared it by closing Access and re-opening it.
> >> But
> >> you shouldn't have to do this at all. Something is keeping your table
> >> from
> >> refreshing. Does the table have a unique index on it?
> >>
> >> --
> >> Bill Mosca, MS Access MVP
> >>
> >>
> >> "N[ at ]HUedu" <N[ at ]HUedu[ at ]discussions.microsoft.com> wrote in message
> >> news:EB2F585E-E7A7-4DD7-8886-3CD5BD8BEB47[ at ]microsoft.com...
> >> >I deleted a record from a table, closed the table and on reopening it
> >> >found
> >> > that the record came up as "#deleted". I deleted all relationships with
> >> > other
> >> > tables and eventaully deleted the other tables. Still #deleted
> >> > displayed
> >> > in
> >> > all the controls for the allegedly deleted record. Please help!
> >>
> >>
> >>
>
>
>
|
|
How often to compact really depends on how the database is used. If you are
doing a lot of batch transactions like updates, deletes, inserts and see
that the size of the database file has grown disproportionately, then run
the Compact.
If you don't see much growth, I'd say once a month would probably keep
everything in good shape. But make sure all other users are out of the
database before attempting to compact.
--
Bill Mosca
"N[ at ]HUedu" <NHUedu[ at ]discussions.microsoft.com> wrote in message
news:5F1580D1-3B73-4B14-8DE3-8A54E8A8A272[ at ]microsoft.com...
[Quoted Text] > Thanks Bill. The compact & repair worked! How often should it be done?
>
> "Bill Mosca, MS Access MVP" wrote:
>
>> You have misunderstood the term "linked". A linked table is one that i
>> snot
>> in the database. It is in another database. If the table resides in your
>> database, the DELETED in the field could well mean that your index on the
>> table is bad. Remove all indexes on that table and compact the database.
>> Then create the indexes again. Hopefully, that will fix the problem.
>>
>> I read your response to Karl. There is nothing drastic about compacting
>> your
>> database. In fact it should be done routinely.
>>
>> --
>> Bill Mosca, MS Access MVP
>>
>>
|
|
|