auto-number field type

[Guest]

I want to do a SQL query to import data to my Access db from another Access
db. Most of the ID fields I want to import are Long Integer the same as an
auto-number key field. There are two that the match keys are double.
So what happens if I import that? I noticed there are no double types
available in the auto-number type.

thanks,

 

[Arvin Meyer [MVP]]

Autonumber is a special long integer, i.e. one that does not repeat itself
and either generates random or sequential value. If you import a double
datatype, it will stay a double. Which means that it won't autogenerate a
value, but it can have decimals. If your data has decimals, a double is the
type you want. If it doesn't, change the datatype to a long integer since
it's half the size (4 bytes instead of 8) and more efficient.

 

[David W. Fenton]

Autonumber is a special long integer, i.e. one that does not
repeat itself and either generates random or sequential value.

An Autonumber is a long integer field with a special type of default
value.