PC Review


Reply
Thread Tools Rate Thread

Adding a database to a network

 
 
M
Guest
Posts: n/a
 
      10th Jan 2008
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?
 
Reply With Quote
 
 
 
 
Douglas J. Steele
Guest
Posts: n/a
 
      10th Jan 2008
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.

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


"M" <(E-Mail Removed)> wrote in message
news:55CF5250-B678-4C6A-854C-(E-Mail Removed)...
> 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?



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Membership Database to already hosted database cs_in_va Microsoft ASP .NET 1 6th Mar 2008 12:56 PM
Adding database design changes to a database copy =?Utf-8?B?c2FtYWNsYXU=?= Microsoft Access 4 4th Feb 2007 08:38 PM
Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row rjr Microsoft Excel Programming 5 11th Jun 2006 09:43 PM
Adding rows to Dataset and adding to Database =?Utf-8?B?SmF3YWhhcg==?= Microsoft Dot NET 0 12th May 2006 08:17 PM
Adding Access97 database to MS Works database Barry Microsoft Access Database Table Design 1 23rd Sep 2003 04:36 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:52 AM.