Database Compression Question

  • Thread starter Thread starter Dan Bair
  • Start date Start date
D

Dan Bair

Hi;

I am developing in Office XP VBA. I have split my
project into a front-end and back-end. I have code that
connects the front-end to the back-end wherever it may be
and everything is working fine. Multiple users can pound
away at the same database.

QUESTION: On my installation procedure, I include a
database compression shortcut in the
Start/Programs/Project path of the desktop. What happens
if someone tries to compress the database while several
other people are using it and someone is in the process
of updating, adding or deleting a table entry? Should I
remove the compress icon from the user's desktop and only
allow the network administrator to compress the database
in the evening?

Thanks,
Dan
 
Assuming that by "database compression" you're referring to compacting the
database, Access doesn't allow you to compact unless you've got exclusive
access to the database. If you try, you get an error message telling you it
can't be done. In other words, there's probably no harm in letting them have
it (although not much point, either)
 
Back
Top