Why am I losing records in Access?

[rotweiler2885]

I'm using a combination of Access 2003 and Access 2000 and seem to be losing
records each time new data is entered in a database to track shipments. At
first it appeared that the auto number ID's only went to 100, but now that
I've changed the record number type to a 25 character format I'm still
running into problems. Is there a setting about how many records a database
can hold??

 

[SacCourt]

My understanding is that you have a 2G limit on data in Access 2003. You have
allowed the database to be saved in Access 2000 format. This in itself should
not pose a probelm to an ID. An Auto ID is Long Integer and should be a
primary key.

What you describe is a text field that you may or may not be using as a
primary key. If you were able to chane the recreod number to a 25 character
format you are most likely using a text field.

I have used text fields to provide primary key fields. To do this I use a
time and date stamp like:

Me.ShippingNumber = Format(now(),"YYYYMMDDHHMMSS" & Int((999 * Rnd) + 1)

I make it a default data or I generate the time date stamp by an event code.

Turn off the delete function of the form.