Lock problem?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 28 Oct 2004 20:20 GMT

We have 5 networked pc's using Access 2002, under Win98SE. The application
has a BE held on 1 pc with FE's on all 5 pc's. All forms in the FE are set
to shared and a lock on edited record.

What is being experienced is that if user 1 goes into form A on their pc -
no problem, if however user 2, on their own pc, tries to use form A tries
error messages/ problems occur.

Any suggestions as to why this is and how to overcome woutl be appreciated.

TIA
Tom

Reply to this Message

TomU - 28 Oct 2004 22:17 GMT

Do all users have full rights to the share that contains the BE - read,write,
create, delete?

TomU

> We have 5 networked pc's using Access 2002, under Win98SE. The application
> has a BE held on 1 pc with FE's on all 5 pc's. All forms in the FE are set
[quoted text clipped - 8 lines]
> TIA
> Tom

Reply to this Message

Tom - 29 Oct 2004 06:04 GMT

Hi

All users have full rights

Tom

> Do all users have full rights to the share that contains the BE -
> read,write,
[quoted text clipped - 19 lines]
>> TIA
>> Tom

Reply to this Message

Larry Linson - 31 Oct 2004 02:49 GMT

> What is being experienced is that if user
> 1 goes into form A on their pc - no
> problem, if however user 2, on their own
> pc, tries to use form A tries error
>messages/ problems occur.

What are the "error messages/problems"? When it comes to remote debugging,
only specific questions are likely to get useful answers. Because each user
has and is using his/her own front end, the problem you are encountering
_must_ be in accessing the data. Have you tried with the most optimistic
form of locking?

Larry Linson
Microsoft Access MVP

Reply to this Message