INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Maximum number of tables in Access 2003

Maximum number of tables in Access 2003

(OP)
Hello can anyone tell me the maximum number of tables allowed in a 2003 Access Database?

The current database I am working on has 3026.

I can see that the maximum number of open tables is 2048 - but what is the actual limit?

Many thanks

Mark

RE: Maximum number of tables in Access 2003

What are you doing with three THOUSAND tables?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Maximum number of tables in Access 2003

(OP)
It's a professionally purchased system that the client has.

Each time a new client is added to the database a new table is created.

I know this is not 'normal' - but this is how the package is written and is how the data is stored.

It's run for them for 8 years without a problem - so I guess it's doing it's job - but I'm wondering how many tables access is happy with?

Thanks mark.

RE: Maximum number of tables in Access 2003

Not sure about 2003 but 2007-10 have a limit of 32,768 objects in a database.

Duane
Hook'D on Access
MS Access MVP

RE: Maximum number of tables in Access 2003

(OP)
Yes access 2003 is also 32k objects.

So as the database only contains tables, there should not be
foreseeable problems for the company to remain using this software
package.

Many thanks. Mark.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close