Re: Auto Number Not Working
From: Lynn Trapp (ltrappNoSpam_at_ltcomputerdesigns.com)
Date: 07/15/04
- Next message: CMB from Omaha: "Re: access 2000"
- Previous message: Lynn Trapp: "Re: automatically recording date record was edited/added"
- In reply to: Lacybug: "Auto Number Not Working"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Auto Number Not Working"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Auto Number Not Working"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 15 Jul 2004 11:10:33 -0500
Let me make a guess -- you have Access 2000 and have not installed the
latest service pack. There is a known bug in Access 2000 that can cause
Autonumber fields to do this after you compact the database.
-- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Lacybug" <anonymous@discussions.microsoft.com> wrote in message news:2e1bc01c46a7c$89ed0f40$a301280a@phx.gbl... > I have a database we have used for 3 years--all of a > sudden it will not assign a new number. It is pulling an > old one and then indicates it is a duplicate value. I > have it maked as Yes (no duplicates) with long integer. > Can anyone help? Thanks
- Next message: CMB from Omaha: "Re: access 2000"
- Previous message: Lynn Trapp: "Re: automatically recording date record was edited/added"
- In reply to: Lacybug: "Auto Number Not Working"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Auto Number Not Working"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Auto Number Not Working"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
