Network library file

  • Thread starter Thread starter Random
  • Start date Start date
R

Random

Hi,

I'm trying to create a central reporsitory of code some of which is
shared between 4 MS Access applications. At the moment each app has
its own copy of the code, so we have to take care that when changing
one app we change the other 3. I'm thinking of creating a single mde
with all the code modules and then referencing this from the 4 apps.
To complicate matters further the apps can be located on up to 50
different (networked) PC's. If we place the single code mde on the
network for the individual apps to reference, what sort of performance
problems might we encounter? What I'm really asking, is when Access
uses a referenced file at what point does it retrieve any information
from the network?

I'll probably trial it anyway, but any thoughts would be appreciated.

Thanks
Steve
PS running Access 2002. Client PC's mostly use runtime Access (ODE).
 
Whenever the local databases make function calls that are defined in the
library db, that is when network traffic is experienced. Depending on the
capacity of your network and other issues, that has gotta be better than
having to maintain the same database multiple times
 
Back
Top