October 8, 2008 04:31am pdt

1. chapmandew 138,810
2. acperkins 103,316
3. nmcdermaid 82,712
4. cs97jjm3 48,319
5. mark_wills 44,585
6. angelIII 41,135
7. PedroCGD 39,380
8. brejk 36,600
9. EugeneZ 36,222
10. frankytee 27,691
11. dready 20,000
12. matthews... 18,750
13. bhess1 16,550
14. aneeshatti... 14,002
15. Zberteoc 13,800
16. rickchild 13,750
17. momi_sa... 11,250
18. rboyd56 10,525
19. MohammedU 10,325
20. dbaSQL 9,815
21. Yveau 9,700
22. JimFive 8,375
23. TheLearn... 7,830
24. dbbishop 7,800
25. jimpen 7,275

1. acperkins 371,565
2. nmcdermaid 195,429
3. angelIII 181,551
4. arbert 149,684
5. chapmandew 138,810
6. EugeneZ 87,040
7. matthews... 56,804
8. cs97jjm3 54,849
9. aneeshatti... 47,999
10. mark_wills 44,585
11. rboyd56 42,625
12. PedroCGD 40,880
13. ptjcb 38,638
14. brejk 36,600
15. bhess1 36,130
16. twoboats 30,515
17. frankytee 30,441
18. dready 30,430
19. Yveau 30,000
20. Sirees 27,902
21. jltoops 27,275
22. Lowfatsp... 24,059
23. TommyTupa 23,000
24. gbshahaq 22,472
25. ScottPletc... 22,430

05.22.2008 at 03:04PM PDT, ID: 23426056

	[x] Attachment Details

Making Autonumber on existing tables

Asked by kneidels in MS SQL DTS, Microsoft Access Database

hey there

i have an access Db that i down-sized friom an SQL database. the export did not maintain the autonumbers in the database tables.

i know that i cannot swuthc them onto auto number now, so how do i do it? especially seen as the tables are inter-related, so i need to keep the ID numbers

thanks!Start Free Trial

Keywords: Making Autonumber on existing tables

	Title
1	AutoNumber
2	Reset Autonumber field
3	Delete out-of-range AutoNumber Pri…
4	How can i reset the AutoNumber in a t…
5	Create Autonumber in QUERY not TAB…
6	rec.AddNew and AutoNumber

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Making Autonumber on existing tables

Asked by kneidels in MS SQL DTS, Microsoft Access Database

About this solution