[AccessD] Access help needed by my brother's friend

Gary Kjos garykjos at gmail.com
Wed Mar 22 13:51:15 CST 2006


HI Phil,

The first thing that comes to my mind that could be causing your
poblem would be - are the users given sufficient rights on the share
to be able to CREATE, UPDATE and DELETE files on the share??  This
FULL ACCESS is needed so that the LOCK file can be created when the
user opens the database. If the user is not allowed to create files on
the machine acting as the server, then the lock file cannot be created
and so the database will be opened in read only mode.

This will be an easy thing to determine - with the database open, IS
there a file created with the same name as the database but with a
file extension of .LDB instead of the database itself which has an MDB
extension. No LDB file, then no updates.

Gary Kjos
garykjos at gmail.com

On 3/22/06, Kathryn Bassett <kathryn at bassett.net> wrote:
> Phil, I'm forwarding your message to a list called AccessD run by DataBaseAdvisors http://www.databaseadvisors.com/lists/whatandhow.htm as the scope of your request is beyond my skills. I highly recommend you join the list right away to see answers from people who reply to the list instead of directly to you. I'm positive someone will be able to help you.
> --
> Kathryn Rhinehart Bassett (Pasadena CA)
> "Genealogy is my bag" "GH is my soap"
> kathryn at bassett.net
> http://bassett.net
>
> -----Original Message-----
> From: Phil Huisman [mailto:pbhuisman at msn.com]
> Sent: 21 Mar 2006 7:02 am
> To: kathryn at bassett.net
> Subject: Ken Rhinehart
>
> My name is Phil Huisman and your brother Ken gave me your name as a possible contact for help with Microsoft Access. I recently developed an Access database program for a ministry I am involved with at Glenkirk Church called Shepherd's Pantry. We need a DB to track people we serve so I decided to give it a try. After some struggling, I have managed to create a DB I think will meet our needs but there is one problem: we have a network of three PC's at the Pantry and the DB cannot be updated by all three PC's. I did manage to get all three PC's to share the DB but only in the 'read only' mode. Any changes to the database on PC's 2 or 3 cannot be saved? We get an error message but I forget exactly what the message says.
>
> I am using Microsoft Office 2003 Access, and XP Home operating system on new Dell PC's. The three PC's are networked together through a Linksys router. I take it we cannot just use standard Access in a network and be able to update the database from multiple PC's? It occurred to me we made need to have a dedicated server running Windows NT or something like that? Anyway, I hope this makes sense and would certainly appreciate any help you can provide.
>
> Thank you,
>
> Phil Huisman
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


--
Gary Kjos
garykjos at gmail.com



More information about the AccessD mailing list