Can be access by mutiple users?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Just wonder whether MS access report can be accessed by mutiple users at the
same time?

We have a MS access report . We can open it but when you click it and doing
nothing. Someone said because it is only allowed access it one person one
time. Is it right?
 
Jerry,
An excellent reply that covers just about every possibility.
I am, however, curious. I understand the Autocorrect issue, but what is
your objection to Compact On Close? I, personally, have had it in production
in a multiuser database, (properly split with each user having a copy on
their desktop) for 6 years without a problem. Please understand this is not
an argument, but a seek for knowledge.

Thanks,

Klatuu
 
.....maybe because compacting the application does not compact the central
database....

If the application is an MDE with no tables then it would be unlikely to
need to be compacted at all nevermind every time the user shuts it down.
 
I don't like compact on close for various reasons.

1. I've seen people basically pull the plug on their computers when it
wouldn't shut down quickly enough due to Access doing compacting. Of course
this was on badly designed databases that were not split.

2. On my databases I have a new copy of the FE copied to the user's PCs when
they log in so no compacting needed.

3. Compacting is somewhat of a futile pursuit as the database usually just
grows back to the size needed to do sorts and other internal stuff. If the
database is severely bloating, the root cause needs to be fixed and not just
the symptoms.

4. I have seen databases corrupted by compacting. I even had one where it
was reproducible! Turned out that there was a problem with the Microsoft
Office installation. No need to tempt fate for such little gain in compacting.

5. As Craig points out, a properly split database should not need compacting
as the tables are not in the mdb file being closed.
 
Thanks for the input.

Jerry Whittle said:
I don't like compact on close for various reasons.

1. I've seen people basically pull the plug on their computers when it
wouldn't shut down quickly enough due to Access doing compacting. Of course
this was on badly designed databases that were not split.

2. On my databases I have a new copy of the FE copied to the user's PCs when
they log in so no compacting needed.

3. Compacting is somewhat of a futile pursuit as the database usually just
grows back to the size needed to do sorts and other internal stuff. If the
database is severely bloating, the root cause needs to be fixed and not just
the symptoms.

4. I have seen databases corrupted by compacting. I even had one where it
was reproducible! Turned out that there was a problem with the Microsoft
Office installation. No need to tempt fate for such little gain in compacting.

5. As Craig points out, a properly split database should not need compacting
as the tables are not in the mdb file being closed.
Click to expand...
 
Back
Top