compression
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Compression

Compression

resolvedResolved · Low Priority · Version 2007

replyReply Tue 9 Aug 2011, 16:30Delegate Simon said...

Simon has attended:
Access Intermediate course
Access Advanced course

Compression

If you have multi-user access when is compression activated? Only after all users leave system

For upcoming training course dates see: Pricing & availability

replyReply Fri 12 Aug 2011, 17:04Trainer Simon said...

RE: Compression

Hi Simon,

Thank you for your question and welcome to the forum.

You must have the database open in Exclusive mode in order to use the Compact and Close feature in the Access options. So anyone else using the database would have to close it first.

I have put a link below:

http://office.microsoft.com/en-us/access-help/help-prevent-and-correct-database-file-problems-by-using-compact-and-repair-HA010235583.aspx

I hope this answers your question.

Regards

Simon

Fri 19 Aug 2011: Automatically marked as resolved.

 

Please browse our web site to find out more about
access courses and other Microsoft training courses.

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard