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
The COSO Framework consists of six broad classes of control activities. Initial responses should identify and define one of the broad classes (Ex: segregation of duties or indepe

Q. Explain about Octal Numbers system? An octal system has 8 digits signified as 0,1,2,3,4,5,6,7. For finding equal decimal number of an octal number one has to find quantity o

representation of the adjacency matrix and adjacency list

Data can be moved from one field to another using a 'Write:' Statement and stored in the desired format.  Write: Date_1 to Date_2 format DD/MM/YY.

Shadow RAM is a copy of Basic Input/Output Operating System (BIOS) routines from read-only memory (ROM) into a particular area of random access memory (RAM) so that they can be acc

There were 50 respondents to our survey. The first component of the data examined here focuses on student's preference (ecommerce or traditional commerce). The Second compone

The octal equivalent of (247) 10 is ? Ans. (247) 10 = (367) 8

What are the difference between heap and stack? The Stack is more or less responsible for maintaining track of what's executing into our code or what's been "called". The Heap


How to attain 180 degree precise phase shift? Never tell using inverter: a. DCM an inbuilt resource into most of FPGA can be arranged to get 180 degree phase shift. b. BU