Prev: Error Loading DLL, msoutl.olb, Access97
Next: How can I fix runtime error 2293 in Access 2003?
From: Finn.Rudd@Earthlink_QED_SPAM_AVOID_.net on 13 Feb 2005 22:51
Help Pls: Why does Access 2003, when converting a DB from Access 2000,
replace an 'increment' primary-key auto-number "record id #" field, by a
'random' number field for generating " record id #'s," for records I am
now adding to the Data Base, subsequent to the conversion?

The values now generated for new records are lengthy, complex numbers, and
they are cumbersome, and not helpful.

When I try to change this property in 'design' view, back to an 'increment'
setting, as I had originally designed the Data Base, the system returns an
error message saying:

"You can't change a random-valued AutoNumber field to an incremental
AutoNumber field." "(The values of random-valued AutoNumber fields aren't
continuous)"

In converting the data-base, would there have been some way I could have
avoided this ? Thanks much, in advance, for your guidance. FINN RUDD
From: onedaywhen on 14 Feb 2005 08:30

Steve Schapel wrote:
> If you wanted, you could reasonably easily put it back to how it was.

> It would involve making a new table with the same structure as the
> existing one, except with the AutoNumber set to incremental, and
using
> an Append Query to add the records from prior to the convwersion

What if the autonumbers didn't run sequentially, as they rarely do?

Jamie.

--

From: onedaywhen on 15 Feb 2005 10:45

Steve Schapel wrote:
> Jamie
>
> The existing numbers will be appended, whether they are sequential or
not.

Sorry, I thought it wasn't possible to INSERT a value to an autonumber
column. It makes sense now! Thanks for clarifying.

Jamie.

--

 | 
Pages: 1
Prev: Error Loading DLL, msoutl.olb, Access97
Next: How can I fix runtime error 2293 in Access 2003?