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
|
|||
|
|||
adding primary field to existing database
The database exists without a primary field. I now want
to add a primary field. How can I do it at this late stage. |
#2
|
|||
|
|||
adding primary field to existing database
Just add it.
If you're talking about setting an existing field (or fields) to the primary key, highlight the field(s) and click on the Key icon to create the primary key. If you're talking about adding an Autonumber field, it will automatically populate with sequential values, so you can set it to be the primary key as above. Anything else, you could have some problems, since null fields can't be part of a primary key. You'll have to add the field(s) to the table, then populate it/them before you can set the primary key. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (No private e-mails, please) "robyns" wrote in message ... The database exists without a primary field. I now want to add a primary field. How can I do it at this late stage. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adding a year to a date field | Sharon | Mailmerge | 1 | August 5th, 2004 11:03 PM |
Database Window Gone | DaveB | General Discussion | 2 | July 29th, 2004 12:24 AM |
Word Database Field | vree | Mailmerge | 4 | May 5th, 2004 10:01 AM |
Display Binary data ( an OLE object field in Access database) to Excel Cell | Koo | Worksheet Functions | 0 | October 9th, 2003 09:43 AM |