New Record nav button disabled.

  • Thread starter Thread starter Dan Brown
  • Start date Start date
D

Dan Brown

I am experiencing a problem with an Access2000 table and
displaying the data in it. A user somehow "deleted" a
line, the entire row displayed "#Deleted" (about 15
columns). The application would not come up. I was able to
get that row removed, however ever since, when I filter on
an individuals name, the Add New Record Navigation button
is disabled. Also while filtered I am unable to manipulate
the data displayed and get errors like "Recordset not
updateable" (-2147352567 (80020009)). I am using a query
built in VB to set the RecordSource property for the form.
Prior to the "#Deleted" incident I was able to filter on
an individual and work with the data. Any thoughts on
where to look?

Dan
 
-----Original Message-----
I am experiencing a problem with an Access2000 table and
displaying the data in it. A user somehow "deleted" a
line, the entire row displayed "#Deleted" (about 15
columns). The application would not come up. I was able to
get that row removed, however ever since, when I filter on
an individuals name, the Add New Record Navigation button
is disabled. Also while filtered I am unable to manipulate
the data displayed and get errors like "Recordset not
updateable" (-2147352567 (80020009)). I am using a query
built in VB to set the RecordSource property for the form.
Prior to the "#Deleted" incident I was able to filter on
an individual and work with the data. Any thoughts on
where to look?

Dan

.
Have you tried compacting and repairing your db
Click to expand...
 
Yes, I have. Didn't have any effect. I am still searching
for the reason for the #Deleted in every column of a
single row as well.

Dan
 
-----Original Message-----
Yes, I have. Didn't have any effect. I am still searching
for the reason for the #Deleted in every column of a
single row as well.

Dan
Click to expand...

I'm not exactly sure as to the nature of your question,
but it appears you are using access tables and queries to
add data, which should not be done, as many here will
tell you. Forms are for adding data, queries and tables
are just for developing the source for those forms.

As for the #Deleted values in a record (what you're
referring to as a row) that usually means that while the
query was open you or some other user deleted the
selected record directly from a table, or from a form, or
from somewhere besides the query you have open. If you
switch your query to design view and then back to
datasheet view the entire record should be gone. As for
adding data, if you have calculated fields in a query it
is generally not updatable, particularly not directly
from the datasheet view of the query.

Vel.
 
Back
Top