Prev: Access Note table in date order, when go to note form, dates are n
Next: "recover access database"
From: CDS on 10 Dec 2009 17:53
The database is locking out other users. Once the database is closed then
another user can access it.

This was created in Access 2007 as a 2003 format and is operating on an
Access 2003 system. It is on a shared drive on a server and is the only file
on this drive and all users have access.

Some of the settings are listed below.

Settings/Advanced:
Default open mode: Shared
Default record locking: No locks
Open databases by using record-level locking: Checked

If it is not a setting could you advise as to where the problem might be.

Thank you for any assistance,
CDS




From: Gina Whipp on 10 Dec 2009 18:00
CDS,

Sounds like a folder permissions issue, what are the settings on the folder?

As a side note, it sounds like all the users are sharing an unsplit
database. This is bound to cause problems, the more serious being that of
corruption. You should consider splitting, NOW, before it's too late. Here
are some links to assist...

http://www.members.shaw.ca/AlbertKallal/Articles/split/

http://allenbrowne.com/ser-01.html

To handle the update of multiple front ends see...

http://www.autofeupdater.com/

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"CDS" <CDS(a)discussions.microsoft.com> wrote in message
news:3E47181A-86A7-451E-9CE9-8B5A2B1877A9(a)microsoft.com...
> The database is locking out other users. Once the database is closed then
> another user can access it.
>
> This was created in Access 2007 as a 2003 format and is operating on an
> Access 2003 system. It is on a shared drive on a server and is the only
> file
> on this drive and all users have access.
>
> Some of the settings are listed below.
>
> Settings/Advanced:
> Default open mode: Shared
> Default record locking: No locks
> Open databases by using record-level locking: Checked
>
> If it is not a setting could you advise as to where the problem might be.
>
> Thank you for any assistance,
> CDS
>
>
>
>


From: Daniel Pineault on 10 Dec 2009 18:21
Is your database split? If it isn't that should be done before allowing
multiple users to work with it.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"CDS" wrote:

> The database is locking out other users. Once the database is closed then
> another user can access it.
>
> This was created in Access 2007 as a 2003 format and is operating on an
> Access 2003 system. It is on a shared drive on a server and is the only file
> on this drive and all users have access.
>
> Some of the settings are listed below.
>
> Settings/Advanced:
> Default open mode: Shared
> Default record locking: No locks
> Open databases by using record-level locking: Checked
>
> If it is not a setting could you advise as to where the problem might be.
>
> Thank you for any assistance,
> CDS
>
>
>
>
From: CDS on 10 Dec 2009 20:47
Thank you,
Christina

"CDS" wrote:

> The database is locking out other users. Once the database is closed then
> another user can access it.
>
> This was created in Access 2007 as a 2003 format and is operating on an
> Access 2003 system. It is on a shared drive on a server and is the only file
> on this drive and all users have access.
>
> Some of the settings are listed below.
>
> Settings/Advanced:
> Default open mode: Shared
> Default record locking: No locks
> Open databases by using record-level locking: Checked
>
> If it is not a setting could you advise as to where the problem might be.
>
> Thank you for any assistance,
> CDS
>
>
>
>
From: CDS on 10 Dec 2009 20:48
Thank you,
Christina

"Gina Whipp" wrote:

> CDS,
>
> Sounds like a folder permissions issue, what are the settings on the folder?
>
> As a side note, it sounds like all the users are sharing an unsplit
> database. This is bound to cause problems, the more serious being that of
> corruption. You should consider splitting, NOW, before it's too late. Here
> are some links to assist...
>
> http://www.members.shaw.ca/AlbertKallal/Articles/split/
>
> http://allenbrowne.com/ser-01.html
>
> To handle the update of multiple front ends see...
>
> http://www.autofeupdater.com/
>
> --
> Gina Whipp
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "CDS" <CDS(a)discussions.microsoft.com> wrote in message
> news:3E47181A-86A7-451E-9CE9-8B5A2B1877A9(a)microsoft.com...
> > The database is locking out other users. Once the database is closed then
> > another user can access it.
> >
> > This was created in Access 2007 as a 2003 format and is operating on an
> > Access 2003 system. It is on a shared drive on a server and is the only
> > file
> > on this drive and all users have access.
> >
> > Some of the settings are listed below.
> >
> > Settings/Advanced:
> > Default open mode: Shared
> > Default record locking: No locks
> > Open databases by using record-level locking: Checked
> >
> > If it is not a setting could you advise as to where the problem might be.
> >
> > Thank you for any assistance,
> > CDS
> >
> >
> >
> >
>
>
> .
>
 | 
Pages: 1
Prev: Access Note table in date order, when go to note form, dates are n
Next: "recover access database"