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 various threats posed through servers into a client server environment. Server Destroyed within an Accident: Power failures, Leaking pipes and equipment failures are no

What are the steps in a BDC session? The first step in a BDC session is to recognize the screens of the transaction that the program will process.  Next step is to write a pro

State the advantages Off-the-shelf -  tends to be less expensive as development costs can be spread over many users -  can be more sophisticated as large sales bring in c

What are the Advantages of store program control (I) Easy to maintain (II) Easy to control (III) Wide range of services can be provided to customers (IV) Flexible

What are various types of Shift Registers ? Ans: Kinds of Shift Registers: (i) SISO that is Serial-In Serial-Out Shift Register (ii) SIPO that is Serial-In P

write a program to copt values of object without using copy constructor or = operator

Varien, the company that owns Magento, formerly worked with osCommerce. They originally planned to discontinue osCommerce but later decided to rewrite it as Magento. Magento formal

What is Difference between write back and write through cache? A caching method wherein modifications to data into the cache aren't copied to the cache source till absolutely n

Write short note on Quantization. Quantization: This is the first step in PCM. The whole amplitude range of the modulating signal is divided in a number of standard levels term

write a program to find the area under the curve y=f(x) between x=a and y=b integrate y=f(x) between the limits of a and b. the area under a curve between two points can be found b