1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

importing database in access

Discussion in 'Business Applications' started by williamc, Nov 12, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. williamc

    williamc Thread Starter

    Joined:
    Jul 19, 2004
    Messages:
    72
    I'm trying to import a database to an existing database. Both are identical, aside from their WO_NUM field, which distinguishes each record (and is primary key).

    I have enough information in the database fields to make the database I want to import match. The problem is that the database is not allowing me to manually enter data. When I try a manual increment of the WO_NUM table, I am getting the following message:



    ODBC-call failed.

    [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of UNIQUE KEY constraint 'UC_TASKS_WOID_1'. Cannot insert duplicate key in object 'TASKS'.(#2627)[Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated. (#3621)



    Any help is appreciated. Thank you.
     
  2. Ziggy1

    Ziggy1

    Joined:
    Jun 17, 2002
    Messages:
    2,551
    I'm assuming you are importing the tables, it seems like you are importing the primary key also, that will cause a problem because there will be duplicates.

    You can try dumping the table into Excel and strip off the ID column and then import the excel table or Paste it into the table. Access will create new ID's for it.
     
  3. Rockn

    Rockn

    Joined:
    Jul 29, 2001
    Messages:
    21,334
    From the looks of the error message it looks like you have a field in the table set to not accept duplicates.
     
  4. williamc

    williamc Thread Starter

    Joined:
    Jul 19, 2004
    Messages:
    72
    Thanks for the suggestions. Still no luck though.

    I tried the methods mentioned, but I am unable to increment the table, even by doing it one record at a time. By going to the last row, I tried pressing enter and typing in the next available field number. I still get the error message when I move to the next cell. The table is linked to another called LASTWOID. I've determined that this is where the TASKS table determines the last key value and increments from it. It only contains a number value associated with the record in the TASKS table.

    Any other ideas?

    William
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/295647

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice