#DELETED - Error in Access-97 and Access-2000

[vishnu]

Hello..
I have an application in Access-97 and it has been
upgraded to MS-Access 200 now. Now I converted that
application to Access-2000. After that I have a problem
with a form (Master/Detail).

In the detailed section of the form there are nearly 20
fields that are bounded to the from Record source (Acts as
a grid). Now the problem I am facing is while creating a
new record. I can fill the various fields in the detailed
section. But when I press the "Tab" Key and go to the next
line (new record), all the fileds in the privious row are
filled with "#DELETED". But the data in the privious row
are saved in the tables. I can see the data once I requery
the form. I will appreciate any help in this regards..
Thanks in Advace.
Vishnu

 

[Ki Yi [MS]]

Hello,

First, try creating an Access 2000 database and then import all the objects
(such as tables, queries, etc). If this doesn't help then
create a simple new subform (detail) and see if the same problem occurs.

Also make sure the you have the latest updates for JET and Access:

Q276367 OFF2000: How to Obtain the Latest Office 2000 Service Pack
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q276367

Q239114 ACC2000: Updated Version of Microsoft Jet 4.0 Available in Download
Center
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q239114

Hope this helps!

Ki

 

[vishnu]

Hello Ki,
I recreated the form again. But still the error is
appearing. One strange thing is the #DELETED is appearning
only for some data. For some data it is fine without any
problems. I also downloaded the latest JET and installed.
Still I am getting the error..
Regards,
Vishnu