I have a database (an appointment-type database) where the items will be deleted quite frequently, e.g.
Table appointments:
ID : autonumber
date : date/time
When the appointment time has expired, I'd like to delete that entry (to keep my DB from getting too large). My question is, since autonumber will just keep adding 1 to the ID for each record entered into the table, will the value eventually go out of bounds? Will it somehow wrap around?
Thanks
Table appointments:
ID : autonumber
date : date/time
When the appointment time has expired, I'd like to delete that entry (to keep my DB from getting too large). My question is, since autonumber will just keep adding 1 to the ID for each record entered into the table, will the value eventually go out of bounds? Will it somehow wrap around?
Thanks