Drastic decrease in database size after adding new user, why? 1

[Spruce4U]

My database is shared by many users, and thus is secured at user level.

Recently, I added a new user (using 'user-level security assistant'), and realized that the size of my Access DB had passed from 31 Mb to 7 Mb after the procedure, but apparently without any loss of data.

A bit worrying!

Has anyone seen this?

 

[lespaul]

sounds like someone ran the compact and repair utility.


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[Spruce4U]

Thanks lespaul.

Apparently, Access automatically runs the compact and repair command (which I didn't know about before you told me) when you add users to a secured DB.

That's good to know.

Many thanks again,



Sébastien