Can I Begin Autonumber >1

In my database therer is now a need to have a table that begins the primary
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7640-can-i-begin-autonumber-1-a.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7640
key ID that begins with a number greater than 10,000.
The reason for this is because now we have to link two tables with similar
information (formerly was just one table) to a reference table, and it will
fall over if two id's are the same. I thought if I could make the ID's
different there wouldn't be an issue with this. Any ideas would be
appreciated. Many thanks.

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

I apologise, my searching needs work. Here is a reply from Steve Schapel that
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7640
answered my question:


Marko,

Open a blank query in design view, and enter 99999 in the Field row of
the first column of the query design grid. Make it an Append Query
(select Append from the Query menu), and nominate your table. In the
Append To row of the grid, enter the name of the Autonumber field. The
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7640
SQL of the query will look something like this....
INSERT INTO [YourTable] ( YourAutoNumberField )
SELECT 99999 AS Expr1;

Run the query (click the toolbar button with the red [!] icon). Close
the query, open the table, and selete this record just added. After
that, the next record added will have 100000 in the autonumber field.

--
Steve Schapel, Microsoft Access MVP

I think this article should help:

http://www.mvps.org/access/tables/tbl0005.htm

THT

Rico

Note: that many questions have already been answered (like yours), have a
search through the forum before asking your question.

"Ben" wrote:

> In my database therer is now a need to have a table that begins the primary
> key ID that begins with a number greater than 10,000.
> The reason for this is because now we have to link two tables with similar
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7640
> information (formerly was just one table) to a reference table, and it will
> fall over if two id's are the same. I thought if I could make the ID's
> different there wouldn't be an issue with this. Any ideas would be
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7640
> appreciated. Many thanks.