Results 1 to 6 of 6
  1. #1
    bugchaser is offline Novice
    Windows Vista Access 2003
    Join Date
    Feb 2009
    Location
    Sydney
    Posts
    4

    Duplicate record failure

    Hi everyone

    I have a duplicate record button on a form which has been created by the wizard.

    All works fine on my PC but when the program is run on a client's computer she gets the error message "
    update or cancel update with out addnew or edit" when attempting to duplicate a record.

    We are both using Windows Vista and Access 2003 with the only difference is she also has Access 2007 on her PC.

    Any help would be greatly appreciated.

    Thank you.



  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Double check the References on both machines, especially the order of ADO and DAO.

  3. #3
    bugchaser is offline Novice
    Windows Vista Access 2003
    Join Date
    Feb 2009
    Location
    Sydney
    Posts
    4
    Thanks for your reply Allan, but could you please clarify as I am not familiar with the ADO/DAO order.

    Thank you.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I suspect you have not disambiguated your Dim statements (Dim RS As DAO.RecordSet - as opposed to Dim RS As RecordSet) so Access uses the first library it comes to in the References. If both DAO and ADO are included, the order that appear in the references list is important. The best solution is to disambiguate your Dim statements.

  5. #5
    bugchaser is offline Novice
    Windows Vista Access 2003
    Join Date
    Feb 2009
    Location
    Sydney
    Posts
    4
    Thanks Allan I shall try your solution. Does this happen due to the fact that Access 2007 is present on the same machine ?

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The order of the library references stays with the machine, not with the db.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. duplicate autonumber
    By rayc in forum Access
    Replies: 5
    Last Post: 06-19-2013, 07:50 AM
  2. If duplicate record, go to original record
    By BigBear in forum Forms
    Replies: 2
    Last Post: 10-06-2010, 02:58 AM
  3. Replies: 0
    Last Post: 01-06-2009, 02:17 PM
  4. Duplicate add to new table
    By horseyshoe in forum Access
    Replies: 3
    Last Post: 09-01-2006, 07:51 AM
  5. Which duplicate?
    By grgerhard in forum Import/Export Data
    Replies: 1
    Last Post: 05-27-2006, 06:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums