Forum home » Delegate support and help forum » Microsoft Access Training and help » Database design

Database design

ResolvedVersion 2003

Wed 18 Feb 2009, 16:30 Delegate Nanna said...

Nanna has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Project Intro Intermediate course

Database design

At what number of tables does a database become too unruly?

Sat 21 Feb 2009, 21:02 Trainer Cress said...

RE: Database design

Hello Nanna
Thank you for your question. This depends on how much data you have in the tables, there isnt a set answer here. However, here is a link to a page which discusses the limitations of Microsoft Access:

http://www.databasezone.com/techdocs/acclimit.html

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips

Database design

Database design

RE: Database design

Access articles

Access tip:

Hide Access Tables