Results 1 to 2 of 2

Thread: #delete record

  1. #1
    Join Date
    Nov 2006
    Posts
    43

    Unanswered: #delete record

    I have linked a table to MS Access 2003 from SQL 2000 server and figured there are some records with all the field value #delete. When I use Query Analyzer, I am sure those records contain values instead of #delete. Or even when I import the table instead of link, I can get correct values. Can anyone please advise a solution because I need to link a table? Thanks.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Those records do not contain any values! #delete is telling you that the record has been deleted! When the form is required this will disappear.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •