Hi.
These sound a lot like homework questions.
What is the capacity of an mdb file?
An MDB file has the capacity to hold data, queries, VBA code, macros, form
and report objects, metadata, llinks to tables in other files, and
import/export specifications.
How many entries can you put in a table?
Up to two entries if you are using Jet 4.0 (Access 2K, 2002, and 2003) and
it's a memo field almost 1 GB. Only one entry if it's Jet 3.0 or 3.5 (Access
95 or Access 97 SR-2) and a nearly 1 GB memo field. Of course, you can fit a
lot more entries in the tables if your records are smaller. It's size that
counts, not how many times you try.
What is the size limit for an mdb file?
Depends upon which version of Jet you are using. 2 GB for Jet 4.0. 1 GB
for Jet 3.0 or 3.5.
Is there a limit to the amounts of queries and reports an mdb file can
accommodate?
Yes. An MDB file can hold 32,768 total objects. Objects include tables,
queries, forms, reports, modules, macros, and Data Access Pages.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
