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
Explain the characteristics and utilities available into java that makes it appropriate for developing e-commerce applications. Following are the characteristics and utilities

The disadvantages of specifying parameter assignments using defparam are: -  Parameter  is  essentially specified  by  the  scope  of  hierarchies  underneath  which  it exists

What is meant by scan code?  When a key is pressed on the keyboard, the keyboard controller places a code take to the key pressed into a part of the memory known as the keyboar

What are subroutines? Subroutines are program modules, which can be known  from other ABAP/4 programs or within the similar program.

Explain the term- Looking at existing paperwork This allows analyst to see how paper files are kept and look at operating instructions and check accounts, training manuals etc

The Utilization Count shows the status of each processor in a specific mode i.e.  Overhead mode, busy mode, and idle mode with respect to the progress in time as shown in Figure.

Q. What do you mean by PROC Directive? PROC Directive: Code segment comprises executable code for a program that includes one or more procedures defined initially with PROC dir

create a stored procedure to debit a bank account user must enter account no. and amount to debited from account .the minimum balance in account should be 500. if the debited amoun

#example of cascading rollback#

The aim of this Assignment is to demonstrate knowledge about the analysis and design of a software system and understanding of the application of an object-oriented metho