(Msg. 1) Posted: Fri May 01, 2009 9:19 am
Post subject: network install Archived from groups: microsoft>public>access>setupconfig (more info?)
I have a split database that I installed on a small office network. There is
no actual or independent server. I placed the backend in the shared folder.
Each front end is on each hard drive and they are linked to the back end. The
problem is that only the computer that is being used as the "server" computer
is the only one that is reading and writing to the backend correctly. The
other networked computer can read the data, but cannot write to it.
So, my question is, can this type of setup even work in Access and if so,
what can I try to troubleshoot the problem? I am using Access 2007 but the
file is in a 2003 format.
TIA.
(Msg. 2) Posted: Fri May 01, 2009 4:46 pm
Post subject: Re: network install [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Every user must have at least Read and Write privileges on the folder where
the MDB file exists. (It's usual to give them Delete as well).
Can the users create text files in the folder and write to them?
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Deb H" <DebH.TakeThisOut@discussions.microsoft.com> wrote in message
news:1F9E8D6E-4702-41D6-82E7-6B6F0684CD72@microsoft.com...
>I have a split database that I installed on a small office network. There
>is
> no actual or independent server. I placed the backend in the shared
> folder.
> Each front end is on each hard drive and they are linked to the back end.
> The
> problem is that only the computer that is being used as the "server"
> computer
> is the only one that is reading and writing to the backend correctly. The
> other networked computer can read the data, but cannot write to it.
> So, my question is, can this type of setup even work in Access and if so,
> what can I try to troubleshoot the problem? I am using Access 2007 but the
> file is in a 2003 format.
> TIA.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum