Compact & Repairing

Resolved · High Priority · Version 2016

Thu 1 Feb 2018, 14:24 Delegate Bhavin said...

Bhavin has attended:
Access Introduction course

Compact & Repairing

Hi!

Is there a way of automatically "Compact & Repairing" a database after running a multiple queries?

Many Thanks

B

Thu 1 Feb 2018, 21:17 Trainer Jens said...

RE: Compact & Repairing

Hi Bhavin,

Thank you for the forum question.

Yes but it must be VBA coded.

You can "Compact & Repairing" automatically every time you close the database. You will find this option under Access Options -> Current database.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 2 Feb 2018, 11:33 Delegate Bhavin said...

RE: Compact & Repairing

Hi Jens,

Thank you for your assitance.

Is there any way you could show me how the VBA coding works for this please?

Thanks!

B

Fri 2 Feb 2018, 17:52 Trainer Jens said...

RE: Compact & Repairing

Hi Bhavin,

To use Access VBA in a database can be very complicated and you will have to understand VBA. I do not know if you have VBA knowledge or programming knowledge, but you will need a onQuery event to tricker the Compact and Repairing tool.

Why do you want to do, what you want?

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 5 Feb 2018, 10:27 Trainer Wendy said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Mon 12 Feb 2018: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips