Hello,

I was going to use the automatic compact function for my database. But I
was wondering if I have multiple users in the database at one time, whenever
one logs out of the database will it break. Thanks

and any suggestions

Hi Lee

Do you mean the automatic "Compact on close" option? It will not fail if
the database is opened by someone else. It will just do nothing. The
database will be compacted when the last person closes it.

If you are talking about writing your own code to compact a back-end file,
what I do is move the file to a "Pre-Compact Backups" folder, and then
compact it back to the original location. If the file is opened by someone
else then the rename fails and the resulting error can be trapped and a
user-friendly message displayed.

--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

"Lee" <(E-Mail Removed)> wrote in message
news:292B02AD-75BA-4CE9-8EE3-(E-Mail Removed)...
> Hello,
>
> I was going to use the automatic compact function for my database. But I
> was wondering if I have multiple users in the database at one time,
> whenever
> one logs out of the database will it break. Thanks
>
> and any suggestions