What is the size limitation of an access database, Computer Engineering

Size limitation does not relate to number of records in a table within a database. Forms, reports, macros, and modules also add to database size, but is rather minimal compared to tables having records. It is recommended that if big amounts of data will be maintained or constantly deleted and latest data imported, put your tables in another database and link the tables back into the major database. The utilities for database compression and repair will run much more quickly. In Access 2.0 databases the byte size limitation is 1 gigabyte. In common, use the 1gb rule and suggestions here to keep performance of the database. See also "How Replication Increases Size of Database.".              

 

 

Posted Date: 4/3/2013 6:07:02 AM | Location : United States







Related Discussions:- What is the size limitation of an access database, Assignment Help, Ask Question on What is the size limitation of an access database, Get Answer, Expert's Help, What is the size limitation of an access database Discussions

Write discussion on What is the size limitation of an access database
Your posts are moderated
Related Questions
What are the different message types available in the ABAP/4 ? There are 5 types of message types available. E: ERROR W-WARNING I -INFORMATION A-ABNORMAL TERMINA

Normal 0 false false false EN-US X-NONE X-NONE

What are the standard types of files produced? A PDF file is universally recognized by the internet and is also a secure image, given that an electronic footprint remains when

Q. Features of read-only memory? ROMs are memories on which it's not possible to write data when they are on-line to computer. They can only be read. This is reason why it is k

Assume that you have been asked to solve problem with exact area constraints, the area error being no more than 1% for each department. What are the linear equations you would nee

PROCEDURE TO CREATE PROJECT IN COLLABORATION SYSTEM

The Throughput graph represents the amount of data in bytes that the Vusers received from the server in a second. When we evaluate this with the transaction response time, we will

Question: 1. In Flash, what is the purpose of a motion guide layer? 2. Differentiate between Motion and Shape tween. 3. Give the steps to create a layer mask in flash.

Vector Processing with Pipelining Because in vector processing vector instructions execute the similar computation on various data operands repeatedly, vector processing is the

A Master group consists of? A master group have 300 voice channels.