Error Message when trying to manual copy records from diff DB

This is a discussion on "Error Message when trying to manual copy records from diff DB" within the Databases section. This forum, and the thread "Error Message when trying to manual copy records from diff DB are both part of the Program Your Website category.



Go Back   Webforumz.com > Main Forums > Program Your Website > Databases

Notices


Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old Jan 27th, 2006, 02:19
New Member
Join Date: Jan 2006
Age: 23
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Exclamation Error Message when trying to manual copy records from diff DB

Hi. I am doing manual copy from one table in a database to another table in another database. While copying, an error message appeared. It says
Code: Select all
The changes you have requested to the table were not successful because they would create duplicate values ub the index, primary key, or in relationship. Change the data in the field(s) that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
I have already tried to unset any primary keys defined in the tables but still the error message appears when I want to copy the same records to the table. And I have also checked the "index" on the table to unset any rules that does not allow duplication of values.

I don't know what causes this error message to pop up. I welcome all opinions & ideas from you. Thanks.
Reply With Quote

  #2 (permalink)  
Old Jan 27th, 2006, 06:39
New Member
Join Date: Jan 2006
Age: 23
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Error Message when trying to manual copy records from diff DB

I found the solution as to why I kept getting errors when I tried to cntrl-C & cntrl-V data from a table to another table. In the database, go to the Design View and click on the Indexes view. In there, my requirements "Unique Allowed?", was already been set as a Yes indicating that no duplicating values are allowed in the rows. So, when I set it to No, all the records can be copied. But I do need your opinions on how to maintain a table that has > 300,000 rows of records.
Reply With Quote
Reply

Tags
error, message, trying, manual, copy, records, diff

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Javascript Copy to clipboard Object Error andrewlondon JavaScript Forum 1 Sep 24th, 2007 13:15
Keep getting error message Microsoft VBScript runtime error '800a01a8' cpando1974 Classic ASP 2 Aug 7th, 2007 12:00
systex error backup copy Aaron1988 Databases 2 Mar 4th, 2007 22:45
Please Help Fix This Error Message DannyP43 JavaScript Forum 3 Sep 26th, 2006 22:04
error message cant get straight monkboy12345 PHP Forum 1 Apr 15th, 2005 21:34


All times are GMT. The time now is 12:50.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43