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 CA N I change an autonumber field in Access 2000?
Sorry, I think this question is very simple, but, I have been reading
Microsoft Help Access and I can't make work it!!! Anybody can give me a better light in my problem? Here is my case: I have a Table that has a primary key Customer ID and it has a current autonumber 23010. Now I want change that number with a new range example... 60000. My sadness is when I try complete the instructions from Acces 2003 sample in Microsoft, It doesn't work. When I try to run the add query I can't get add new record with the new autonumber. I don't why... Any light please... |
#2
|
|||
|
|||
HOW CA N I change an autonumber field in Access 2000?
Access assigns the Autonumbers. This is a bad use of Autonumber. You cannot
rely on their values. Gaps occur anytime you go to a new record and undo it or if you delete a record. Autonumbers should NEVER be used for anything other than PK/FK relationships. Perhaps if you give us the business rule you are trying to satisfy, we can help with a solution. "JJfrustraded" wrote: Sorry, I think this question is very simple, but, I have been reading Microsoft Help Access and I can't make work it!!! Anybody can give me a better light in my problem? Here is my case: I have a Table that has a primary key Customer ID and it has a current autonumber 23010. Now I want change that number with a new range example... 60000. My sadness is when I try complete the instructions from Acces 2003 sample in Microsoft, It doesn't work. When I try to run the add query I can't get add new record with the new autonumber. I don't why... Any light please... |
#3
|
|||
|
|||
HOW CA N I change an autonumber field in Access 2000?
You need to append a new row to the table with a value one less than the
number you wish to start at, e.g. with the following 'append' query: INSERT INTO MyTable (MyID,Firstname,LastName) VALUES(59999, "Dummy", "Dummy"); Then delete the dummy row. However autonumbers are really just to guarantee uniqueness. If you want sequential ranges its best to compute the numbers. You'll find a demo of mine for this at: http://community.compuserve.com/n/pf...ag=ws-msoffice Ken Sheridan Stafford, England "JJfrustraded" wrote: Sorry, I think this question is very simple, but, I have been reading Microsoft Help Access and I can't make work it!!! Anybody can give me a better light in my problem? Here is my case: I have a Table that has a primary key Customer ID and it has a current autonumber 23010. Now I want change that number with a new range example... 60000. My sadness is when I try complete the instructions from Acces 2003 sample in Microsoft, It doesn't work. When I try to run the add query I can't get add new record with the new autonumber. I don't why... Any light please... |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to launch Access 97 from Word 2000 | bof | Setup, Installing & Configuration | 4 | September 7th, 2005 06:26 PM |
Ambiguous Name Error | pm | Using Forms | 10 | June 5th, 2005 09:19 PM |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 07:36 AM |
Upload Image | Jason MacKenzie | General Discussion | 1 | September 1st, 2004 04:38 AM |
Autonumber | Ally H. | General Discussion | 7 | August 27th, 2004 04:51 PM |