Multiple Users

[Briank]

I have set up a db that is being accessed by 5 users at a
time. There are some start up macros that imports data
from Excel. The problem is that when user #2 boots up
the database moves extremely slow. Is there anyway that
I can have the startup macros not run if the db is
already open?

 

[xpii]

Instead of using macros to import data from excel, try
building a linked table pointing to an excel sheet. Also,
are you using a split configured database? That is,
tables in one container and client app
(forms/queries/etc) in another. You should consider this
if currently, all users are accessing the same database.
Last, 2 things can really bog down a database. Do the
following: In table design / properties - set
subdatasheet name to [none] for all tables. 2nd - Under
tools / options / general - set Track Name Autocorrect
Info to off (unchecked) Doing those two things greatly
sped up my applications. If you're not already doing so,
I would strongly advise a split-configured system. If you
need help with that, contact me - (e-mail address removed).

 

[Tim]

This works if you want the macro to run only once per day.

1. Create a new table holding a date field.

2. Amend the start-up macro to update that field to the
system date at the end of the macro.

3. Add a condition to the macro so that it only runs if
the date in the new table is less that today.