And the new pk field is of course empty and autonum so when you append the old table in to the new structure, it should renumber. I might not be good at explaining myself here.
Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Wednesday, May 16, 2012 11:01 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Auto Number and duplicates
Liz
There are dups in the tables, so I get a nasty error saying that violations are preventing it from appending. I am not much of a violating person
Jim Wagner
________________________________
________________________________
From: Liz Ravenwood <liz_ravenwood@beaerospace.com>
To: "'MS_Access_Professionals@yahoogroups.com'" <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, May 16, 2012 10:44 AM
Subject: RE: [MS_AccessPros] Auto Number and duplicates
0. BACK UP All Stuff
1. copy structure on to a new table/s structure only
2. amend new table design/s to have an additional pk autonum, and the old autonum to just num
3. append/paste old table to new table/s
4. establish new relationships based on the new pk (but I'd leave the old number's behind for reference)
Look at what you get and see it it links out okay
Best of luck. What a fun little mess.
Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Wednesday, May 16, 2012 10:38 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Auto Number and duplicates
I failed to mention that there is a related table with task details that are linked together
Jim Wagner
________________________________
________________________________
From: luvmymelody <luvmymelody@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, May 16, 2012 10:33 AM
Subject: [MS_AccessPros] Auto Number and duplicates
Hello everyone,
I just discovered that my Auto number has duplicates. So I checked the design and it has Yes(Duplicates OK). First of all my ignorance was that I always thought Auto numbers would be indexed as no dups. So Now how do I renumber these tasks?
Thank You
Jim Wagner
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Tidak ada komentar:
Posting Komentar