AutoNumber Field Limits - NOT "How do I reset?"
in [General]
|
Prev: Rounding difference in Access 2003 text exports
Next: Attaching a 2003 Access data base to an email for use with Office
From: Tony Toews [MVP] on 5 Apr 2010 22:44 "david" <david(a)nospam.au> wrote: >This uses up autonumbers, and bloats the database to the extent of any >records which are rejected. And given how Jet 4.0 appears to work this might be one 4k page per record that was in the append query before records were rejected. Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ For a convenient utility to keep your users FEs and other files updated see http://www.autofeupdater.com/ Granite Fleet Manager http://www.granitefleet.com/
From: david on 6 Apr 2010 07:01
> And given how Jet 4.0 appears to work this might be one 4k page per > record that was in the append query before records were rejected. I think I remember that there was a specific fix/update to prevent that happening. (david) "Tony Toews [MVP]" <ttoews(a)telusplanet.net> wrote in message news:hv7lr59n4m7mivkc8mo31ins6lr7l4f4n1(a)4ax.com... > "david" <david(a)nospam.au> wrote: > >>This uses up autonumbers, and bloats the database to the extent of any >>records which are rejected. > > And given how Jet 4.0 appears to work this might be one 4k page per > record that was in the append query before records were rejected. > > Tony > -- > Tony Toews, Microsoft Access MVP > Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm > Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ > For a convenient utility to keep your users FEs and other files > updated see http://www.autofeupdater.com/ > Granite Fleet Manager http://www.granitefleet.com/ |