I have and '03 Database on a server with the Back End in a folder on the same
server.

My problem is that the "Lock" will not always disengage. I go in to make
changes in the forms and it tells me that it is locked because someone is
using it, but they're not. I disabled the upper right "x" to close the
database so they could only use an Exit button, but that didn't work.

What can I do to fix this? The big guys are getting tired of having to go
in and clear it so I can work on it.

Thank you in advance for any help.
G

On Sun, 22 Mar 2009 16:53:01 -0700, Gee <(E-Mail Removed)> wrote:

>I have and '03 Database on a server with the Back End in a folder on the same
>server.
>
>My problem is that the "Lock" will not always disengage. I go in to make
>changes in the forms and it tells me that it is locked because someone is
>using it, but they're not. I disabled the upper right "x" to close the
>database so they could only use an Exit button, but that didn't work.
>
>What can I do to fix this? The big guys are getting tired of having to go
>in and clear it so I can work on it.
>
>Thank you in advance for any help.
>G

If you're using a single shared frontend linked to a shared backend, you're
getting the WORST combination: all the problems of a shared database (such as
the locking you see) with none of the benefits!

If you do need to put the frontend on the server, at least give each user
their own private copy in their own private folder.
--

John W. Vinson [MVP]

1. Do you have Compact On Close turned on? If there's an error, it may stop
your closing.

2. Do you have a Boolean control with code like:

If Me.chkWhatever Then

There is a bug in VBA that can hang Access. Change your code to:

If Me.chkWhatever = True Then

3. Do you have any recordsets that haven't been explicitly closed? Make sure
that your exit routine closes all the objects that you open (as opposed to
object used by the application)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Gee" <(E-Mail Removed)> wrote in message
news70B3C70-7CC9-4467-A4B4-(E-Mail Removed)...
>I have and '03 Database on a server with the Back End in a folder on the
>same
> server.
>
> My problem is that the "Lock" will not always disengage. I go in to make
> changes in the forms and it tells me that it is locked because someone is
> using it, but they're not. I disabled the upper right "x" to close the
> database so they could only use an Exit button, but that didn't work.
>
> What can I do to fix this? The big guys are getting tired of having to go
> in and clear it so I can work on it.
>
> Thank you in advance for any help.
> G

there are no benefits to a shared Jet database.

all there is involves:
corruption
bad performance
mountains of vba code (that won't run anywhere else)

the alternative.. is a simple client-server database.. that is
designed -- from the ground up-- to support multiple users.

you don't need 3 tiers of Jet.
You need to upsize to SQL Server.

-Aaron









On Mar 22, 6:14*pm, John W. Vinson
<jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
> On Sun, 22 Mar 2009 16:53:01 -0700, Gee <G...@discussions.microsoft.com> wrote:
> >I have and '03 Database on a server with the Back End in a folder on thesame
> >server.
>
> >My problem is that the "Lock" will not always disengage. *I go in to make
> >changes in the forms and it tells me that it is locked because someone is
> >using it, but they're not. *I disabled the upper right "x" to close the
> >database so they could only use an Exit button, but that didn't work.
>
> >What can I do to fix this? *The big guys are getting tired of having to go
> >in and clear it so I can work on it.
>
> >Thank you in advance for any help.
> >G
>
> If you're using a single shared frontend linked to a shared backend, you're
> getting the WORST combination: all the problems of a shared database (such as
> the locking you see) with none of the benefits!
>
> If you do need to put the frontend on the server, at least give each user
> their own private copy in their own private folder.
> --
>
> * * * * * * *John W. Vinson [MVP]

Arvin;

So sorry that your database access library makes you explicitly close
all your variables.

This is a horrible horrible Jet bug and most people-- when they see
something like this-- they move to a real platform like SQL Server

-Aaron

On Mar 22, 6:19*pm, "Arvin Meyer MVP" <arv...@mvps.invalid> wrote:
> 1. Do you have Compact On Close turned on? If there's an error, it may stop
> your closing.
>
> 2. Do you have a Boolean control with code like:
>
> * * If Me.chkWhatever Then
>
> There is a bug in VBA that can hang Access. Change your code to:
>
> * * If Me.chkWhatever = True Then
>
> 3. Do you have any recordsets that haven't been explicitly closed? Make sure
> that your exit routine closes all the objects that you open (as opposed to
> object used by the application)
> --
> Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com
>
> "Gee" <G...@discussions.microsoft.com> wrote in message
>
> news70B3C70-7CC9-4467-A4B4-(E-Mail Removed)...
>
>
>
> >I have and '03 Database on a server with the Back End in a folder on the
> >same
> > server.
>
> > My problem is that the "Lock" will not always disengage. *I go in to make
> > changes in the forms and it tells me that it is locked because someone is
> > using it, but they're not. *I disabled the upper right "x" to close the
> > database so they could only use an Exit button, but that didn't work.
>
> > What can I do to fix this? *The big guys are getting tired of having to go
> > in and clear it so I can work on it.
>
> > Thank you in advance for any help.
> > G- Hide quoted text -
>
> - Show quoted text -

So sorry that SQL-Server doesn't have a front-end. FWIW, the bugs occur in
VBA not Access and do so no matter whether the data engine is either Jet or
SQL-Server.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


<(E-Mail Removed)> wrote in message
news:d2302e34-958e-48ba-8be9-(E-Mail Removed)...
Arvin;

So sorry that your database access library makes you explicitly close
all your variables.

This is a horrible horrible Jet bug and most people-- when they see
something like this-- they move to a real platform like SQL Server

-Aaron

On Mar 22, 6:19 pm, "Arvin Meyer MVP" <arv...@mvps.invalid> wrote:
> 1. Do you have Compact On Close turned on? If there's an error, it may
> stop
> your closing.
>
> 2. Do you have a Boolean control with code like:
>
> If Me.chkWhatever Then
>
> There is a bug in VBA that can hang Access. Change your code to:
>
> If Me.chkWhatever = True Then
>
> 3. Do you have any recordsets that haven't been explicitly closed? Make
> sure
> that your exit routine closes all the objects that you open (as opposed to
> object used by the application)
> --
> Arvin Meyer, MCP,
> MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com
>
> "Gee" <G...@discussions.microsoft.com> wrote in message
>
> news70B3C70-7CC9-4467-A4B4-(E-Mail Removed)...
>
>
>
> >I have and '03 Database on a server with the Back End in a folder on the
> >same
> > server.
>
> > My problem is that the "Lock" will not always disengage. I go in to make
> > changes in the forms and it tells me that it is locked because someone
> > is
> > using it, but they're not. I disabled the upper right "x" to close the
> > database so they could only use an Exit button, but that didn't work.
>
> > What can I do to fix this? The big guys are getting tired of having to
> > go
> > in and clear it so I can work on it.
>
> > Thank you in advance for any help.
> > G- Hide quoted text -
>
> - Show quoted text -

SQL Server has a frontend.

It is called 'access data projects'.
or 'Reporting Services'.

-Aaron




On Mar 23, 7:57*pm, "Arvin Meyer MVP" <arv...@mvps.invalid> wrote:
> So sorry that SQL-Server doesn't have a front-end. FWIW, the bugs occur in
> VBA not Access and do so no matter whether the data engine is either Jet or
> SQL-Server.
> --
> Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com
>
> <aaron.ke...@gmail.com> wrote in message
>
> news:d2302e34-958e-48ba-8be9-(E-Mail Removed)...
> Arvin;
>
> So sorry that your database access library makes you explicitly close
> all your variables.
>
> This is a horrible horrible Jet bug and most people-- when they see
> something like this-- they move to a real platform like SQL Server
>
> -Aaron
>
> On Mar 22, 6:19 pm, "Arvin Meyer MVP" <arv...@mvps.invalid> wrote:
>
> > 1. Do you have Compact On Close turned on? If there's an error, it may
> > stop
> > your closing.
>
> > 2. Do you have a Boolean control with code like:
>
> > If Me.chkWhatever Then
>
> > There is a bug in VBA that can hang Access. Change your code to:
>
> > If Me.chkWhatever = True Then
>
> > 3. Do you have any recordsets that haven't been explicitly closed? Make
> > sure
> > that your exit routine closes all the objects that you open (as opposedto
> > object used by the application)
> > --
> > Arvin Meyer, MCP,
> > MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmv...
>
> > "Gee" <G...@discussions.microsoft.com> wrote in message
>
> >news70B3C70-7CC9-4467-A4B4-(E-Mail Removed)...
>
> > >I have and '03 Database on a server with the Back End in a folder on the
> > >same
> > > server.
>
> > > My problem is that the "Lock" will not always disengage. I go in to make
> > > changes in the forms and it tells me that it is locked because someone
> > > is
> > > using it, but they're not. I disabled the upper right "x" to close the
> > > database so they could only use an Exit button, but that didn't work.
>
> > > What can I do to fix this? The big guys are getting tired of having to
> > > go
> > > in and clear it so I can work on it.
>
> > > Thank you in advance for any help.
> > > G- Hide quoted text -
>
> > - Show quoted text -

and sorry the bugs occur _WHERE_?

I don't have to de-instantiate my ADO recordsets, why do you put up
with a DAL that gives memory leaks?

-Aaron




On Mar 23, 7:57*pm, "Arvin Meyer MVP" <arv...@mvps.invalid> wrote:
> So sorry that SQL-Server doesn't have a front-end. FWIW, the bugs occur in
> VBA not Access and do so no matter whether the data engine is either Jet or
> SQL-Server.
>
> Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com
>
> <aaron.ke...@gmail.com> wrote in message
>
> news:d2302e34-958e-48ba-8be9-(E-Mail Removed)...
> Arvin;
>
> So sorry that your database access library makes you explicitly close
> all your variables.
>
> This is a horrible horrible Jet bug and most people-- when they see
> something like this-- they move to a real platform like SQL Server
>
> -Aaron
>
> On Mar 22, 6:19 pm, "Arvin Meyer MVP" <arv...@mvps.invalid> wrote:
>
> > 1. Do you have Compact On Close turned on? If there's an error, it may
> > stop
> > your closing.
>
> > 2. Do you have a Boolean control with code like:
>
> > If Me.chkWhatever Then
>
> > There is a bug in VBA that can hang Access. Change your code to:
>
> > If Me.chkWhatever = True Then
>
> > 3. Do you have any recordsets that haven't been explicitly closed? Make
> > sure
> > that your exit routine closes all the objects that you open (as opposedto
> > object used by the application)
> > --
> > Arvin Meyer, MCP,
> > MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmv...
>
> > "Gee" <G...@discussions.microsoft.com> wrote in message
>
> >news70B3C70-7CC9-4467-A4B4-(E-Mail Removed)...
>
> > >I have and '03 Database on a server with the Back End in a folder on the
> > >same
> > > server.
>
> > > My problem is that the "Lock" will not always disengage. I go in to make
> > > changes in the forms and it tells me that it is locked because someone
> > > is
> > > using it, but they're not. I disabled the upper right "x" to close the
> > > database so they could only use an Exit button, but that didn't work.
>
> > > What can I do to fix this? The big guys are getting tired of having to
> > > go
> > > in and clear it so I can work on it.
>
> > > Thank you in advance for any help.
> > > G- Hide quoted text -
>
> > - Show quoted text -

Wow, lots of discussion but I really didn't get an answer that I can
understand.

What do I need to do to make the break when the program is closed?

I can't be the only one facing this problem.

Help?

Thanks,
Gee

"(E-Mail Removed)" wrote:

> and sorry the bugs occur _WHERE_?
>
> I don't have to de-instantiate my ADO recordsets, why do you put up
> with a DAL that gives memory leaks?
>
> -Aaron
>
>
>
>
> On Mar 23, 7:57 pm, "Arvin Meyer MVP" <arv...@mvps.invalid> wrote:
> > So sorry that SQL-Server doesn't have a front-end. FWIW, the bugs occur in
> > VBA not Access and do so no matter whether the data engine is either Jet or
> > SQL-Server.
> >
> > Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com
> >
> > <aaron.ke...@gmail.com> wrote in message
> >
> > news:d2302e34-958e-48ba-8be9-(E-Mail Removed)...
> > Arvin;
> >
> > So sorry that your database access library makes you explicitly close
> > all your variables.
> >
> > This is a horrible horrible Jet bug and most people-- when they see
> > something like this-- they move to a real platform like SQL Server
> >
> > -Aaron
> >
> > On Mar 22, 6:19 pm, "Arvin Meyer MVP" <arv...@mvps.invalid> wrote:
> >
> > > 1. Do you have Compact On Close turned on? If there's an error, it may
> > > stop
> > > your closing.
> >
> > > 2. Do you have a Boolean control with code like:
> >
> > > If Me.chkWhatever Then
> >
> > > There is a bug in VBA that can hang Access. Change your code to:
> >
> > > If Me.chkWhatever = True Then
> >
> > > 3. Do you have any recordsets that haven't been explicitly closed? Make
> > > sure
> > > that your exit routine closes all the objects that you open (as opposed to
> > > object used by the application)
> > > --
> > > Arvin Meyer, MCP,
> > > MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmv...
> >
> > > "Gee" <G...@discussions.microsoft.com> wrote in message
> >
> > >news70B3C70-7CC9-4467-A4B4-(E-Mail Removed)...
> >
> > > >I have and '03 Database on a server with the Back End in a folder on the
> > > >same
> > > > server.
> >
> > > > My problem is that the "Lock" will not always disengage. I go in to make
> > > > changes in the forms and it tells me that it is locked because someone
> > > > is
> > > > using it, but they're not. I disabled the upper right "x" to close the
> > > > database so they could only use an Exit button, but that didn't work.
> >
> > > > What can I do to fix this? The big guys are getting tired of having to
> > > > go
> > > > in and clear it so I can work on it.
> >
> > > > Thank you in advance for any help.
> > > > G- Hide quoted text -
> >
> > > - Show quoted text -
>
>

On Sun, 22 Mar 2009 16:53:01 -0700, Gee <(E-Mail Removed)> wrote:

>I have and '03 Database on a server with the Back End in a folder on the same
>server.

That's your problem.

If you have all the users sharing the same frontend you will constantly have
locking issues.

Give each user their own copy of the database, on their own machine
(preferably), or in their own private folder on the server if that's
necessary.
--

John W. Vinson [MVP]