Access to access database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

iainskye - 12 Sep 2007 13:20 GMT

I have a small home network with a simple shared database that 3 pcs can
access. We all have admin rights. Suddenly today if pc 1 & 2 are using the
database pc 3 cant access it. Pc 3 can access the database as long as pc 1 &
2 aren't using it.

Can someone help me please??

Reply to this Message

Douglas J. Steele - 12 Sep 2007 13:41 GMT

Make sure that all users have a minimum of Read, Write and eXecute
permissions on the folder where the database exists. (Usually you also want
to grant them Delete permission as well)

Signature

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

>I have a small home network with a simple shared database that 3 pcs can
> access. We all have admin rights. Suddenly today if pc 1 & 2 are using
[quoted text clipped - 4 lines]
>
> Can someone help me please??

Reply to this Message

iainskye - 12 Sep 2007 14:56 GMT

Thank you

Yes folder permissions are set for read, write, execute & delete. Still
have the same problem as before. Anything else you could suggest for me
please??

> Make sure that all users have a minimum of Read, Write and eXecute
> permissions on the folder where the database exists. (Usually you also want
[quoted text clipped - 8 lines]
> >
> > Can someone help me please??

Reply to this Message

Douglas J. Steele - 12 Sep 2007 15:04 GMT

Is PC3 perhaps trying to open the database exclusively?

Signature

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

> Thank you
>
[quoted text clipped - 17 lines]
>> >
>> > Can someone help me please??

Reply to this Message

iainskye - 12 Sep 2007 15:24 GMT

perhaps, can you tell me how I can check this? I am not very sure of what is
needed to do this.

> Is PC3 perhaps trying to open the database exclusively?
>
[quoted text clipped - 19 lines]
> >> >
> >> > Can someone help me please??

Reply to this Message

Douglas J. Steele - 12 Sep 2007 15:50 GMT

How is the database being opened from PC3? If via a shortcut, check the
shortcut to make sure /excl hasn't been included as a parameter.

If it's being opened from within Access using File | Open Database, make
sure the Exclusive checkbox isn't checked.

As well, look on the Advanced tab under Tools | Options.

Signature

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

> perhaps, can you tell me how I can check this? I am not very sure of what
> is
[quoted text clipped - 27 lines]
>> >> >
>> >> > Can someone help me please??

Reply to this Message