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 / Multiuser / Networking / July 2005

Tip: Looking for answers? Try searching our database.

Multi-users sharing a frontend?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Leslie Isaacs - 20 Jun 2005 15:48 GMT
Hello All

I have a split A2k db on a 30-user network, with each workstation having its
own frontend (on its C drive) and all with linked tables which are in a db
on the fileserver.
All works fine, except that it is very laborious when I make design changes
to the frontend - I have to manually copy and past the new frontend onto
everyone's workstation. I think this could be done with a proper system of
version control and batch copying, but I don't have the expertise to do
this - and I'm the nearest thing we have here to an expert!! I was
wondering, though, about having a single fronend, on the server, that
everyone uses. Although there are about 30 users in total, it would be very
rare that more than 4-5 of them wanted access to the db at the same time.

Is this idea worth pursuing, or is it a definite no-no?

I would be very grateful for any advice.

Many thanks
Leslie Isaacs
Fred Boer - 20 Jun 2005 15:56 GMT
Dear Leslie:

You might want to investigate the following:

http://www.granite.ab.ca/access/autofe.htm

http://rogersaccesslibrary.com/TableOfContents3.asp

Oh, and multiple users of front end on server.... that's a no-no.. you'll
increase the chance of boo-boos in your files! ;)

HTH
Fred Boer

> Hello All
>
[quoted text clipped - 19 lines]
> Many thanks
> Leslie Isaacs
Fred Boer - 20 Jun 2005 16:03 GMT
Whoops! Look for "KeepingDatabasesInSync" in Roger's Access Library...

Sorry!
Fred

> http://rogersaccesslibrary.com/TableOfContents3.asp

> Oh, and multiple users of front end on server.... that's a no-no.. you'll
> increase the chance of boo-boos in your files! ;)
[quoted text clipped - 27 lines]
>> Many thanks
>> Leslie Isaacs
Jesper F - 21 Jun 2005 12:27 GMT
Tony Toews AutoFEupdater works great for me in an office with 25 users.
I just email the updated frontends to my contact person on site -> he puts
it on their network drive ->
the next time a user runs the db the new file is automatically copied to
their c-drive.

Jesper
Tom - 15 Jul 2005 19:44 GMT
I made a batch file that copies the frontend file that I maintain on the
server. This frontend file is moved to the user each time they open it by
using the batch file icon on their deaktop.

> Hello All
>
[quoted text clipped - 16 lines]
> Many thanks
> Leslie Isaacs
 
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.