Rabu, 25 Maret 2015

[MS_AccessPros] existing consecutive numbered field to autonumber

 

Pros,

 

I have a table that for some antiquated and irrelevant-now reason the pk is a long integer that gets incremented programmatically.

 

Of course, it should be autonumber.

 

However, I have a bunch of data in the table and rely on that pk and need it to remain the same values.

 

How do I go about this again?  It seems like I’ve done this, but it might have been something akin but not exactly.

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 |

beaerospace.com

Passion to Innovate. Power to Deliver

 



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.

__._,_.___

Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar