Why am I losing records in Access?

[Guest]

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??

 

[Joseph Meehan]

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??

More information might be helpful . How are you using this combination
of 2003 & 2000 are there any other problems. How many users? How
experienced - careful are they?

Also have you tried to do a repair and compact?

 

[Guest]

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.