record limit?

[Rob]

I have a form that is used to track paperwork submitted.
When I enter the person's SSN it will show their name and
other data from the personnel table on the form and enter
a new record in the form table. These two tables are
linked by the SSN fields. Everything works fine except
when I enter the SSN of a person's whose record is the
221st or higher in the personnel table. The first 220
records work fine, but I can't get it to work with
anything higher.

Is this a limit in Access? Is there anyway to work around
this?

Thanks,
Rob

 

[John Vinson]

I have a form that is used to track paperwork submitted.
When I enter the person's SSN it will show their name and
other data from the personnel table on the form and enter
a new record in the form table. These two tables are
linked by the SSN fields. Everything works fine except
when I enter the SSN of a person's whose record is the
221st or higher in the personnel table. The first 220
records work fine, but I can't get it to work with
anything higher.

Is this a limit in Access? Is there anyway to work around
this?

There is a limit of two gigabytes in any single .mdb file. Ten million
records in a single table is getting pretty big... 221 records is
TINY.

There is some other problem happening here! What's "not working"? What
are you doing to "show their name and other data"? What's the
recordsource for your form, and what if any VBA code do you have on
it?