Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

'ms access+course' - access

Forum home » Delegate support and help forum » Microsoft Access Training and help » 'ms access+course' - Access

'ms access+course' - Access

ResolvedVersion Standard

Melissa has attended:
Access Introduction course

Access

What is the maximum amount of tables that can be present in any one database?

RE: Access

Hi Melissa

Interesting question.

I have looked into it and I think the number of tables in a database will be imposed by your operating system and the maximum file size allowed.

This means that the maximum number of tables of an average Windows XP based Access database is about 65,536 which, I think also includes the system tables (somewhere between 10 and 99).

If your database ever gets this big you should rethink the design.

Carlos

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.