Re: Linked DB Question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Cheryl Fischer (cherylfischer_at_NOSPAMmsn.com)
Date: 04/03/04


Date: Sat, 3 Apr 2004 07:30:02 -0600

Dave,

Each person who needs to use your database must have Full Network
Permissions (Read, Write, Modify, Create, Delete) to the folder where your
database resides. This is so the first user to open the database can
create the Access LDB (or locking) file associated with the database, the
subsequent users can modify the LDB when they open the database (and close
it), and so that the last user can delete the LDB file when he or she closes
the database.

--
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
"Dave Elliott" <mynotebook@sbcglobal.net> wrote in message
news:FVnbc.4470$TQ5.3718@newssvr24.news.prodigy.com...
> Does the folder where the tables are have to be shared?
> Also does the folder have to allow network users to change my files?
>
>


Relevant Pages

  • Re: File Corruption
    ... a shared folder on the network. ... This is probably the most common cause of corruption. ... There is never any valid excuse not to split a database. ...
    (microsoft.public.access.gettingstarted)
  • Re: Is This Possible ... ? Yes - Upload images to an Access database
    ... It looks like your databases folder is outside the root of your web ... I created a database exactly as you said, the only change I made was to ... and underneath an 'upload' button and a 'view images' button. ... Dim con As New Data.OleDb.OleDbConnection ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Securing A Folder On A Server
    ... this is a matter of network permissions rather than ... involve putting the database users in an AD/NT group that can read files ... in the folder but cannot ... The database admin will save the docs to the folder. ...
    (microsoft.public.access.gettingstarted)
  • Re: Have database mismatch, can I move NTDS.dit and Exchange to new identical server?
    ... Check the physical location of the Winnt\NTDS\ folder. ... Check the permissions on the \Winnt\NTDS folder. ... as it may not be the database that is the ... MCSA + Exchange ...
    (microsoft.public.win2000.active_directory)
  • Re: issue with data location
    ... but for a database LOCAL_APPDATA would probably be ... I was leaving aside the network concerns for a moment. ... In cases of stand alone computers I'll store it on the APPData folder. ... and set this folder as the database location. ...
    (microsoft.public.vb.general.discussion)