A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

HOW CA N I change an autonumber field in Access 2000?



 
 
Thread Tools Display Modes
  #1  
Old February 14th, 2006, 06:39 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default 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  
Old February 14th, 2006, 07:35 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default 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  
Old February 14th, 2006, 07:43 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 07:06 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.