Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / March 2007

Tip: Looking for answers? Try searching our database.

On The Network Or Not

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Devlin - 28 Mar 2007 04:54 GMT
Is it better to distribute the front end app to the users or keep it on the
network with back end files?  

Which way gives the quickest response times?

Thanks for taking the time.
tina - 28 Mar 2007 05:17 GMT
there should be a separate copy of the frontend db for each user, regardless
of whether it is housed on the server or on each user's hard drive. as for
response time, consider that a file (any file) opened from the server has to
be transmitted on the data line between the server and the client PC - while
a file that is already on the client PC does not have to compete for
available bandwidth to get to there. so it depends on how busy the "highway"
between the network and the client PCs is, at any given time. usually, the
recommended setup is to house a copy of the FE db on each user's hard drive.

hth

> Is it better to distribute the front end app to the users or keep it on the
> network with back end files?
>
> Which way gives the quickest response times?
>
> Thanks for taking the time.
Devlin - 28 Mar 2007 15:14 GMT
I agree and appreciate your input.

Thanks again!

> there should be a separate copy of the frontend db for each user, regardless
> of whether it is housed on the server or on each user's hard drive. as for
[quoted text clipped - 14 lines]
> >
> > Thanks for taking the time.
tina - 29 Mar 2007 03:51 GMT
you're welcome  :)

> I agree and appreciate your input.
>
[quoted text clipped - 18 lines]
> > >
> > > Thanks for taking the time.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.