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 / January 2008

Tip: Looking for answers? Try searching our database.

Adding a database to a network

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
M - 10 Jan 2008 18:37 GMT
This may be a simple question.

How do I take a database I have created on my computer and
add it to an existing network?
Douglas J. Steele - 10 Jan 2008 19:39 GMT
First, you should split the database into a front-end (containing the
queries, forms, reports, macros and modules), linked to a back-end
(containing the tables and relationships). Only the back-end should be on
the server: each user should have his/her own copy of the front-end. Doing
this significantly reduces the likelihood of database corruption. It also
reduces some network traffic, since it's not necessary to transfer stuff
like form and report definitions across the wire.

Each user needs Read, Write and Create permission on the folder where the
back-end database resides. It's also usual (but not 100% essential) that
each user have Delete permission on that folder. This is because a locking
file (.ldb) gets created in that folder (and no, it's not possible to have
it created somewhere else). The first user to connect to the database causes
the locking file to be created, it's updated by all users connected to the
database, and deleted as the last user disconnects.

Other than that, nothing special needs to be done to use your application.
Access is multiuser enabled out of the box.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> This may be a simple question.
>
> How do I take a database I have created on my computer and
> add it to an existing network?
 
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.