If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#DELETED - Error in Access-97 and Access-2000
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 |
#2
|
|||
|
|||
#DELETED - Error in Access-97 and Access-2000
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...;EN-US;q276367 Q239114 ACC2000: Updated Version of Microsoft Jet 4.0 Available in Download Center http://support.microsoft.com/default...;EN-US;q239114 Hope this helps! Ki |
#3
|
|||
|
|||
#DELETED - Error in Access-97 and Access-2000
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 -----Original Message----- 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...scid=KB;EN-US; q276367 Q239114 ACC2000: Updated Version of Microsoft Jet 4.0 Available in Download Center http://support.microsoft.com/default...scid=KB;EN-US; q239114 Hope this helps! Ki . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2003 | RK | General Discussion | 12 | June 14th, 2004 10:16 AM |
Problem running Access 2003 and Access 2000 apps on same machine. | Rathtap | General Discussion | 3 | June 13th, 2004 01:30 AM |
Access 2000 DB opening with Access 97 | Cathy | General Discussion | 1 | June 8th, 2004 06:16 PM |
Cannot use OpenArgs in Access 2000 | Peter Afonin | Setting Up & Running Reports | 4 | May 18th, 2004 07:19 PM |
Access 2000 .adp and SQL 2000 | Wayne H. | New Users | 0 | May 3rd, 2004 08:28 PM |