Form fields show "#Deleted" after inserting new record

Posted on 2004-03-25
Last Modified: 2006-11-17
I have an Access 2002 front end pointing to SQL Server 2000.

On one continuous form I have, I have a problem when I add a new record and save it by moving to the next one. What happens is that all the fields in the newly added recordchange to "#DELETED"!

If I close the form and open it, the records are there!

Question by:BigJ
  • 3
  • 2
LVL 34

Expert Comment

ID: 10683230
have you tried the REQUERY event after the save?

Author Comment

ID: 10691188
It turned out to be a bug in Access that relates to indexing in SQL Server...
LVL 34

Expert Comment

ID: 10691839
Please close the question....
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.


Author Comment

ID: 10693612
not sure how, there's no 'close' button... There used to be, a long time ago.
LVL 34

Expert Comment

ID: 10695398
Post a "question" in CS with a link to this question and ask to delete/refund....

Accepted Solution

ee_ai_construct earned 0 total points
ID: 10733877
Closed, 400 points refunded.
Community Support Moderator
(re-order part number xm34)

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSIS On fail action 5 38
MS SQL: Return all results in a single row separated by commas 1 26
sql server query 12 25
SQL Find Carriage Return and Delete it. 3 11
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question