Jfakes (your name?)
In addition to John's response, I'd like to add that if you do not want users to delete records you can set up your forms to not allow deletions. And NEVER allow them direct access to the tables.
Other than that, there really isn't a need for AutoNumbers to be absolutely without gaps. In fact, there is no need for the users to even see the ANs as they are meaningless to the user.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Jfakes-
>
> "Missing" AutoNumber values are quite normal. If a user starts to create a
> record in a table that has an AutoNumber, Access allocates the number as soon as
> the record is "dirty." If the user then clears the edits and doesn't save the
> record, the number allocated is "used up" and will create a gap in the sequence.
>
> If there are truly records in older backups that are not in the current
> database, is it possible that the user can delete rows? That would also create
> gaps.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of jfakes.rm
> Sent: Thursday, May 26, 2011 3:30 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Losing data and non-consecutive autonumbers
>
> I had someone at my office contact me and ask me about the below issue. I'm not
> sure what is going on, if it is a LAN issue, design issue, user issue, or what.
>
> Any suggestions?
>
>
> "I still keep losing data though and can't figure it out. Have an autonumber
> field that assigns a consecutive number to each record as it is entered. Some
> days there are several non consecutive numbers. the backend is backed up daily.
> I can compare 2 separate backups a week apart and find records in the older one
> that are missing from the newer one.
>
> Its a head scratcher."
>
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar