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

  • Thread starter Thread starter vishnu
  • Start date Start date
V

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
 
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
 
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
 
Back
Top