 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / November 2007Share a database frontend with several users
How do i share a database frontend with several users over a network? Not entirely sure what you mean. Typically Access applications are split in front-ends (everything except tables, and linked tables) and back-ends (tables), with the former living on each workstation, and the latter on the server. The MDW file (should you decide to use Access-level security) should also be on the server. -Tom. >How do i share a database frontend with several users over a network? >How do i share a database frontend with several users over a network? You want to put the FE on each machine or place in a user specific directory on the server. This will help avoid some weird error messages when users are changing the same forms record source, filters and such as well as corruptions. It is also much easier to implement a new version of the database with changed queries, forms, reports and VBA code. I specifically created the Auto FE Updater utility so that I could make changes to the FE MDE as often as I wanted and be quite confident that the next time someone went to run the app that it would pull in the latest version. For more info on the errors or the Auto FE Updater utility see the free Auto FE Updater utility at http://www.granite.ab.ca/access/autofe.htm at my website to keep the FE on each PC up to date. Tony  SignatureTony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ I m not sure how to separate the frontend from the backend. Could you direct me to a site that has that information or mention it yourself? Thanks for your help. >I m not sure how to separate the frontend from the backend. Could you > direct me to a site that has that information or mention it yourself? > Thanks for your help. http://www.granite.ab.ca/access/splitapp/index.htm Keith. www.keithwilby.com Thank you, your information has helped me to a huge extent... > Thank you, your information has helped me to a huge extent... All credit to Tony Toews, not me. >http://www.granite.ab.ca/access/splitapp/index.htm Took the words right out of my keyboard. But I should've added that in the first place. Thanks, Tony SignatureTony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ |
Reply to this Message |
 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
|
©2009 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.