troubleshooting Autonumber in Access

[Guest]

I've set up a very large but basic table using Autonumber as the primary key.
It's worked fine for months. Today, all of a sudden, when adding a new
contact, the AutoNumber jumped from "34601" to "93324059". I did not add or
delete any new contacts in between. I'd much rather have smaller key #'s than
that - how can I fix this without losing the Autonumber function?

 

[Guest]

Hi,
why does this matter? The autonumber as a primary key is only for access to
work internally correct, It should have no meaning to you or your users.
If you want a meaningful number then create a seperate field and use a dmax
function to create a sequential increasing number.
You might want to try compact and repair (tools--database utilities...) to
fix your autonumber, but again it shouldn't matter!
HTH
Good luck

 

[dbahooker]

Domain Aggregate functions are super slow; i would stick with the built
in autonumber

are you sure you didn't change it from an incremeent to a random? on
the field properties?

 

[Rick Brandt]

Domain Aggregate functions are super slow; i would stick with the
built in autonumber [snip]

Another inaccurate statement. Have you ever actually used Access?

 

[Guest]

Rick,

This will be one of the few times that I'll agree with Aaron. Domain
aggregrate functions used in queries can lead to slow performance. See the
Performance Tips section of this page at FMS:

List of Errors, Suggestions, and Performance Tips (for Total Access
Analyzer)
http://www.fmsinc.com/products/analyzer/ErrorsList.html

The advice printed on a Performance Tips report, regarding Domain Aggregrate
Functions, is as follows (I copied it verbatim from an existing report):

<Begin Quote>

Module Domain Functions in Code

Domain functions such as DLookup, DMin, Max, etc. are often slower than an
equivalent saved query. Where possible, consider replacing Domain functions
with saved queries that are optimized for performance.

<End Quote>

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html

 

[dbahooker]

wow Tom thanks man

i love that website.. i mean-- where he's talking about the lifeCycle..
i mean WOW

i just wish that someone with some respect in the community would come
out in support of ADP.

if someone from FMS; or a single MVP took adp seriously.. i mean--
maybe Access would be a viable option.
as it is; MDB is half the functionaliy of crystal reports; tied to a
crappy database and query engine.

maybe thats the problem-- that there IS no engine for an MDB database..