I Have A Questions

[Tim via AccessMonster.com]

I have the questiosn...

How man tables cane their be in an Microsaft Access Databases? And Homany
Reports, Queryes, Macros, and Moduels can their be in the Microsoft Access
Databases?

Why does the file get big and hwo do I make the file small again?

 

[Guest]

Open up an Access database.
Press the F1 key bring up Help.
Type in Access Specifications in the search box.
Click on Access Specifications in the list.
Click on Show All in the upper right corner.
There you are!

 

[Granny Spitz via AccessMonster.com]

How man tables cane their be in an Microsaft Access Databases? And Homany
Reports, Queryes, Macros, and Moduels can their be in the Microsoft Access
Databases?

In Access 2000 and newer, you can have up to 32,768 objects (that's tables,
queries, modules, etc.) and of those 32,768 objects, up to 1,000 can be
modules.

Why does the file get big

Keep adding data. Storing images and large OLE objects and memo fields will
make it get bigger faster.

hwo do I make the file small again?

Tools | Database Utilities | Compact and Repair Database
This gets rid of unused space.

 

[Guest]

Hi Tim,

In Access Help, enter the term: Specifications
You should be able to find the answer to most of your questions here.

To reduce the size of the database, use Tools > Database Utilities > Compact
and repair database. Embedded OLE Objects (ie. pictures, or other files such
as Word documents and spreadsheets) are a known cause of database bloat in
Access 2003 and all prior versions. Access 2007 will offer the ability to
store images without the severe bloating issue.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________