If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do I add an auto-number field to an existing database?
After I'd already started entering info into a new database, I decided that I
did want autonumbering after all. When I tried to add an autonumber field, it tells me that autonumbering can't be applied to databases that already have data entered. What gives? Isnt' there a way around this? |
#2
|
|||
|
|||
You can add a new field to the table, and make the new field an autonumber
type (so long as you don't already have an autonumber field in that table). You can't change an existing field to an autonumber type after you've added data to the table. -- Ken Snell MS ACCESS MVP "Kornfused" wrote in message ... After I'd already started entering info into a new database, I decided that I did want autonumbering after all. When I tried to add an autonumber field, it tells me that autonumbering can't be applied to databases that already have data entered. What gives? Isnt' there a way around this? |
#3
|
|||
|
|||
NOT AT THIS TIME
-----Original Message----- After I'd already started entering info into a new database, I decided that I did want autonumbering after all. When I tried to add an autonumber field, it tells me that autonumbering can't be applied to databases that already have data entered. What gives? Isnt' there a way around this? . |
#4
|
|||
|
|||
=?Utf-8?B?S29ybmZ1c2Vk?= wrote in
: After I'd already started entering info into a new database, I decided that I did want autonumbering after all. When I tried to add an autonumber field, it tells me that autonumbering can't be applied to databases that already have data entered. What gives? Isnt' there a way around this? If you already have numbers that you want to retain as identifiers, then you can keep them and add autonumbering on top. Make a couple of backups first though!! In the database window, copy the table and then paste it back as Structure Only. Delete the old number field and replace it with an Autonumber field with the same name. Now in the Query Designer, make an append query that copies all the records from the old table into the new one: including the old number field into the new number field. Once you are happy that all the records look okay, you can delete the old table, removing any relationships first, though. Rename the new one to the old name. Check all the indexes and re-establish the relationships. The new table will start its autonumbering at one more than the highest number that you imported. Easy! Hope that helps Tim F |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how do you create an auto number field in Access using DDL? | KhalilS | Database Design | 2 | February 28th, 2005 11:40 AM |
Auto Number Field Change | pcteacher | General Discussion | 4 | October 20th, 2004 02:10 AM |
query a number stored as text | Lee | Running & Setting Up Queries | 19 | October 13th, 2004 04:10 AM |
How do I create a calculated field which displays a auto number ? | Adrian | General Discussion | 2 | August 10th, 2004 01:45 PM |
NUMBERING the pages | Bob | New Users | 7 | June 14th, 2004 12:20 AM |