• Register
0 votes


What function does compacting an Access database perform other than reducing the file size?

5 3 2
5,640 points

Please log in or register to answer this question.

2 Answers

0 votes


Repairing the database

6 4 2
10,860 points
0 votes


The Correct Answer Of This Question is repairing the database


Database files can rise quickly as you use them, occasionally impeding performance. They can also sometimes become corrupt or damaged. You can employ the Compact and Repair Database command to prevent or solve these problems. The compact method does not compress your data — it makes your database file smaller by eliminating unused space. The Compact and Repair Database command can also help improve performance of your database.

For Further Reading Go To This Page https://support.office.com/en-us/article/compact-and-repair-a-database-6ee60f16-aed0-40ac-bf22-85fa9f4005b2

10 6 4
31,120 points

Related questions

0 votes
1 answer 123 views
Problem: ____ is the default name for a new table in an Access database?
asked Mar 9, 2020 ArifulIslam 5.6k points
0 votes
2 answers 198 views
Problem: In what type of attack does the attacker send unauthorized commands directly to a database?
asked Apr 12, 2020 ArifulIslam 5.6k points
0 votes
1 answer 9 views
Problem: A user of a database such as that pictured in the accompanying figure refers to a file as what?
asked Aug 4, 2020 LizzyM 6.1k points
0 votes
1 answer 17 views
Problem: The relational database model enables you to view data ____ rather than ____? a. relationally, hierarchically b. hierarchically, relationally c. physically, logically d. logically, physically
asked Jul 21, 2020 HenryL 620 points
0 votes
1 answer 51 views
Problem: I am new and learning, I need help, can anyone help by filling in the blanks? A field in an Access database table that has no value is determined by Access to have a ____ value? A. custom B. zero C. null D. number
asked Feb 21, 2020 maddi86 5.4k points
0 votes
0 answers 42 views
Problem: What does the following UML diagram entry mean? + setHeight(h : double) : void A) this is a public attribute named Height and is a double data type B) this is a private method with no parameters and returns a double data type C) this is a private attribute named Height and is a double data type D) this is a public method with a parameter of data type double and does not return a value
asked Aug 4, 2020 ArifulIslam 5.6k points
0 votes
2 answers 21 views
Problem: What information does the next hop entry in a routing table identify?
asked Apr 12, 2020 ArifulIslam 5.6k points
0 votes
1 answer 32 views
Problem : I am trying to use the custom adapter extending cursor adapter for displaying data in the listview, So that I can display particular phone number that I have passed the id to a method in the database class however it is giving following error : ... mycursor.getColumnIndex("ContactNumber")); mycursor.close(); mydb.close(); return mynum; } Can someone help me to resolve my issue?
asked Dec 9, 2019 alecxe 7.5k points
0 votes
2 answers 58 views
Problem: What Active Directory directory partition holds the DNS database?
asked Apr 12, 2020 ArifulIslam 5.6k points
2 votes
2 answers 36 views
Problem: What is your first step in developing the database?
asked Mar 23, 2020 ArifulIslam 5.6k points