Autonumber

L

LTParry

I am a soldier in Iraq, creating a database for tracking down insurgents. I
am trying to set it up so that several of our subordinate units have the same
database, then export their files to our central database. I am having two
problems. 1) When I import, because the databases are all from the same
original database, there are many replicated key numbers (the key is an
autonumber). It will not import them or create a new key for them. 2) For
some bizzare reason, the key number has suddenly skipped from 1457 to, no
kidding, 42277557. However, in some forms it appears as "4E + 07." I have
enver used Access before creting this database, and so far it has been a
tremendous success. But these are huge connundrums.
 
D

Douglas J. Steele

Did you create a replica of the database? If so, that's why your autonumbers
are skipping: the autonumber field in replicated databases is random, not
sequential (be prepared for negative numbers...)

As to your second issue, make the textbox larger so that it can show the
entire value.
 
L

Larry Daugherty

Thank you for doing what you do!

Your best solution might lie in using Replication. It's a bit more
work getting it going but, once the bugs are out, it will make what
you're doing a breeze.

If you decide to try Replication, there is another newsgroup:
microsoft.public.access.replication that focuses on those issues. Of
course, you can post here as well.

Sometimes it's wise to crosspost: put up to 3 newsgroups in the
newsgroups line. When you do that, an answer in one newsgroup will
propagate to all of them so that everyone will know shot's been posted
into a thread.

HTH
 
Top