There is no "record limit" when using JET tables. The limit is on the
total size of the MDB file where the JET tables reside. For Access 2000
that limit is 2GB. Obviously then, the number of records allowed within
that limit varies with table design and what kind of data is being stored.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.