Results 1 to 2 of 2
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    I have had to upsize an Access 2003 BE to SQL Server 2005. This means for each table in SQL Server that has an IDENTITY field i will need to add the optional parameter dbSeeChanges to each recordset used.
    What i would like to know is, does it matter if i use the dbSeeChanges option on tables that dont have an IDENTITY field?
    Also can it be used on local access tables?

    The reason i ask is that it is easier to change all OpenRecordset commands than just the ones that use the IDENTITY field.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    This post has been cross posted, and a solution posted here.
    Regards
    John



Posting Permissions

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