Results 1 to 3 of 3
  1. #1
    MGSP is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2006
    Posts
    3

    Unique Record Identifier for MS SQL Server Tables

    I have been using DoCmd.TransferDatabase... to link to an SQL Server. Usually what I do is delete the table first and then use this command. Most of the tables have a Primary Key and it works fine. However, there are some tables that do not have a Primary Key designated and I get the "Unique Record Indentifer" pop up window, click OK and it continues on. I would like to know if there is a way around having this window come up? Is there something that I can add to DoCmd.TranferDatabase line to automatically do this for me or another command. Locally I do not have access to change anything on the SQL Server Database.



    Thanks.

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    This may not work, but you could try using:

    DoCmd.SetWarnings False

    before the TransferDatabase statement. If you do this, make sure to reverse it later:

    DoCmd.SetWarnings True

  3. #3
    MGSP is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2006
    Posts
    3
    Thanks,
    I already have that in the code.

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

Similar Threads

  1. Joining tables two tables and another table that is not
    By DevintheDude in forum Database Design
    Replies: 0
    Last Post: 09-12-2007, 08:56 AM
  2. query that will contain all unique records
    By halcolm1 in forum Queries
    Replies: 0
    Last Post: 01-19-2007, 05:34 PM
  3. Replies: 0
    Last Post: 11-04-2006, 02:31 AM
  4. How do you export a file with a unique file name
    By Budman42 in forum Import/Export Data
    Replies: 1
    Last Post: 10-15-2006, 06:10 PM
  5. sql server active x - HELP!!!!!!!!!!!!!!
    By Valeda in forum Access
    Replies: 0
    Last Post: 06-27-2006, 01:02 PM

Posting Permissions

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