98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » 'ms access+course' - Access
'ms access+course' - Access
Resolved · Low Priority · Version Standard
Mon 26 Nov 2007, 17:34Delegate Melissa said...
Melissa has attended:
Access Introduction course
Access
What is the maximum amount of tables that can be present in any one database?
Tue 27 Nov 2007, 10:30Trainer Carlos said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Insert The Current DateTo insert the current date into a Table field or Form Text box use: |
