Network library file

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).
 
J

JonWayn

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top