I "borrowed" a subroutine that I found in this group to create a backup of my
backend. (Thanks Ken Snell). Before it runs a backup it checks for a locking
file to make sure that no one else is in the system. This works fine if I
manually close any open forms before I try to run the subroutine. But if I
close forms in vba as part of my function it leaves the locking file and
'believes' someone else is in the system. Can someone tell me how to get rid
of the .ldb file.

How are you closing the forms? It shouldn't matter whether you're closing
them programmatically or manually.

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



"OregonIzer" <(E-Mail Removed)> wrote in message
news:0B47789F-69BE-45ED-89B4-(E-Mail Removed)...
>I "borrowed" a subroutine that I found in this group to create a backup of
>my
> backend. (Thanks Ken Snell). Before it runs a backup it checks for a
> locking
> file to make sure that no one else is in the system. This works fine if I
> manually close any open forms before I try to run the subroutine. But if I
> close forms in vba as part of my function it leaves the locking file and
> 'believes' someone else is in the system. Can someone tell me how to get
> rid
> of the .ldb file.

I expect there's probably a better way but I've never needed to ge
rid of the ldb file in VBA before - if no one else suggests anythin
you could use the 'kill' method to delete it

I initially was just closing the form I expected to be active. I then
realized I should make sure all are closed, so I created:

Public Function ClsForms()
Dim i As Integer
For i = Forms.Count - 1 To 0 Step -1
DoCmd.Close acForm, Forms(i).Name
Next
Connection.Close
End Function

If I watch the directory that the ldb file is in as I manually close forms,
I see it disappear. When I use code to close, it's still there.


"Douglas J. Steele" wrote:

> How are you closing the forms? It shouldn't matter whether you're closing
> them programmatically or manually.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "OregonIzer" <(E-Mail Removed)> wrote in message
> news:0B47789F-69BE-45ED-89B4-(E-Mail Removed)...
> >I "borrowed" a subroutine that I found in this group to create a backup of
> >my
> > backend. (Thanks Ken Snell). Before it runs a backup it checks for a
> > locking
> > file to make sure that no one else is in the system. This works fine if I
> > manually close any open forms before I try to run the subroutine. But if I
> > close forms in vba as part of my function it leaves the locking file and
> > 'believes' someone else is in the system. Can someone tell me how to get
> > rid
> > of the .ldb file.
>
>
>

Oops,
I just noticed that the code I sent isn't what I'm using.
that line
"connection.close"
Is just something I stuck in to show what I think is missing - I forgot to
delete it before I sent the code - also, I was having the exact same result
when I was just closing the one form.

"Douglas J. Steele" wrote:

> How are you closing the forms? It shouldn't matter whether you're closing
> them programmatically or manually.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "OregonIzer" <(E-Mail Removed)> wrote in message
> news:0B47789F-69BE-45ED-89B4-(E-Mail Removed)...
> >I "borrowed" a subroutine that I found in this group to create a backup of
> >my
> > backend. (Thanks Ken Snell). Before it runs a backup it checks for a
> > locking
> > file to make sure that no one else is in the system. This works fine if I
> > manually close any open forms before I try to run the subroutine. But if I
> > close forms in vba as part of my function it leaves the locking file and
> > 'believes' someone else is in the system. Can someone tell me how to get
> > rid
> > of the .ldb file.
>
>
>

That should work: that's essentially what I use successfully in my
applications.

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



"OregonIzer" <(E-Mail Removed)> wrote in message
news:937A7F99-D4F6-442D-9F4B-(E-Mail Removed)...
>I initially was just closing the form I expected to be active. I then
> realized I should make sure all are closed, so I created:
>
> Public Function ClsForms()
> Dim i As Integer
> For i = Forms.Count - 1 To 0 Step -1
> DoCmd.Close acForm, Forms(i).Name
> Next
> Connection.Close
> End Function
>
> If I watch the directory that the ldb file is in as I manually close
> forms,
> I see it disappear. When I use code to close, it's still there.
>
>
> "Douglas J. Steele" wrote:
>
>> How are you closing the forms? It shouldn't matter whether you're closing
>> them programmatically or manually.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>>
>> "OregonIzer" <(E-Mail Removed)> wrote in message
>> news:0B47789F-69BE-45ED-89B4-(E-Mail Removed)...
>> >I "borrowed" a subroutine that I found in this group to create a backup
>> >of
>> >my
>> > backend. (Thanks Ken Snell). Before it runs a backup it checks for a
>> > locking
>> > file to make sure that no one else is in the system. This works fine if
>> > I
>> > manually close any open forms before I try to run the subroutine. But
>> > if I
>> > close forms in vba as part of my function it leaves the locking file
>> > and
>> > 'believes' someone else is in the system. Can someone tell me how to
>> > get
>> > rid
>> > of the .ldb file.
>>
>>
>>

Is there some action I should take to "close the connections"? If so, how
would I do that? (If it isn't clear, I am NOT a programmer)

"Douglas J. Steele" wrote:

> That should work: that's essentially what I use successfully in my
> applications.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "OregonIzer" <(E-Mail Removed)> wrote in message
> news:937A7F99-D4F6-442D-9F4B-(E-Mail Removed)...
> >I initially was just closing the form I expected to be active. I then
> > realized I should make sure all are closed, so I created:
> >
> > Public Function ClsForms()
> > Dim i As Integer
> > For i = Forms.Count - 1 To 0 Step -1
> > DoCmd.Close acForm, Forms(i).Name
> > Next
> > Connection.Close
> > End Function
> >
> > If I watch the directory that the ldb file is in as I manually close
> > forms,
> > I see it disappear. When I use code to close, it's still there.
> >
> >
> > "Douglas J. Steele" wrote:
> >
> >> How are you closing the forms? It shouldn't matter whether you're closing
> >> them programmatically or manually.
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no e-mails, please!)
> >>
> >>
> >>
> >> "OregonIzer" <(E-Mail Removed)> wrote in message
> >> news:0B47789F-69BE-45ED-89B4-(E-Mail Removed)...
> >> >I "borrowed" a subroutine that I found in this group to create a backup
> >> >of
> >> >my
> >> > backend. (Thanks Ken Snell). Before it runs a backup it checks for a
> >> > locking
> >> > file to make sure that no one else is in the system. This works fine if
> >> > I
> >> > manually close any open forms before I try to run the subroutine. But
> >> > if I
> >> > close forms in vba as part of my function it leaves the locking file
> >> > and
> >> > 'believes' someone else is in the system. Can someone tell me how to
> >> > get
> >> > rid
> >> > of the .ldb file.
> >>
> >>
> >>
>
>
>

I tried putting in a "kill" but I get "Permission denied"

"Pringle9984" wrote:

> I expect there's probably a better way but I've never needed to get
> rid of the ldb file in VBA before - if no one else suggests anything
> you could use the 'kill' method to delete it.
>
>

You shouldn't require anything more than you have.

You don't have a report or query open when you're doing this by any chance?

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



"OregonIzer" <(E-Mail Removed)> wrote in message
news:8BEF6C26-9C82-4FD9-8B22-(E-Mail Removed)...
> Is there some action I should take to "close the connections"? If so, how
> would I do that? (If it isn't clear, I am NOT a programmer)
>
> "Douglas J. Steele" wrote:
>
>> That should work: that's essentially what I use successfully in my
>> applications.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>>
>> "OregonIzer" <(E-Mail Removed)> wrote in message
>> news:937A7F99-D4F6-442D-9F4B-(E-Mail Removed)...
>> >I initially was just closing the form I expected to be active. I then
>> > realized I should make sure all are closed, so I created:
>> >
>> > Public Function ClsForms()
>> > Dim i As Integer
>> > For i = Forms.Count - 1 To 0 Step -1
>> > DoCmd.Close acForm, Forms(i).Name
>> > Next
>> > Connection.Close
>> > End Function
>> >
>> > If I watch the directory that the ldb file is in as I manually close
>> > forms,
>> > I see it disappear. When I use code to close, it's still there.
>> >
>> >
>> > "Douglas J. Steele" wrote:
>> >
>> >> How are you closing the forms? It shouldn't matter whether you're
>> >> closing
>> >> them programmatically or manually.
>> >>
>> >> --
>> >> Doug Steele, Microsoft Access MVP
>> >> http://I.Am/DougSteele
>> >> (no e-mails, please!)
>> >>
>> >>
>> >>
>> >> "OregonIzer" <(E-Mail Removed)> wrote in message
>> >> news:0B47789F-69BE-45ED-89B4-(E-Mail Removed)...
>> >> >I "borrowed" a subroutine that I found in this group to create a
>> >> >backup
>> >> >of
>> >> >my
>> >> > backend. (Thanks Ken Snell). Before it runs a backup it checks for a
>> >> > locking
>> >> > file to make sure that no one else is in the system. This works fine
>> >> > if
>> >> > I
>> >> > manually close any open forms before I try to run the subroutine.
>> >> > But
>> >> > if I
>> >> > close forms in vba as part of my function it leaves the locking file
>> >> > and
>> >> > 'believes' someone else is in the system. Can someone tell me how to
>> >> > get
>> >> > rid
>> >> > of the .ldb file.
>> >>
>> >>
>> >>
>>
>>
>>

Nothing is open - the command runs from a button on a toolbar.

"Douglas J. Steele" wrote:

> You shouldn't require anything more than you have.
>
> You don't have a report or query open when you're doing this by any chance?
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "OregonIzer" <(E-Mail Removed)> wrote in message
> news:8BEF6C26-9C82-4FD9-8B22-(E-Mail Removed)...
> > Is there some action I should take to "close the connections"? If so, how
> > would I do that? (If it isn't clear, I am NOT a programmer)
> >
> > "Douglas J. Steele" wrote:
> >
> >> That should work: that's essentially what I use successfully in my
> >> applications.
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no e-mails, please!)
> >>
> >>
> >>
> >> "OregonIzer" <(E-Mail Removed)> wrote in message
> >> news:937A7F99-D4F6-442D-9F4B-(E-Mail Removed)...
> >> >I initially was just closing the form I expected to be active. I then
> >> > realized I should make sure all are closed, so I created:
> >> >
> >> > Public Function ClsForms()
> >> > Dim i As Integer
> >> > For i = Forms.Count - 1 To 0 Step -1
> >> > DoCmd.Close acForm, Forms(i).Name
> >> > Next
> >> > Connection.Close
> >> > End Function
> >> >
> >> > If I watch the directory that the ldb file is in as I manually close
> >> > forms,
> >> > I see it disappear. When I use code to close, it's still there.
> >> >
> >> >
> >> > "Douglas J. Steele" wrote:
> >> >
> >> >> How are you closing the forms? It shouldn't matter whether you're
> >> >> closing
> >> >> them programmatically or manually.
> >> >>
> >> >> --
> >> >> Doug Steele, Microsoft Access MVP
> >> >> http://I.Am/DougSteele
> >> >> (no e-mails, please!)
> >> >>
> >> >>
> >> >>
> >> >> "OregonIzer" <(E-Mail Removed)> wrote in message
> >> >> news:0B47789F-69BE-45ED-89B4-(E-Mail Removed)...
> >> >> >I "borrowed" a subroutine that I found in this group to create a
> >> >> >backup
> >> >> >of
> >> >> >my
> >> >> > backend. (Thanks Ken Snell). Before it runs a backup it checks for a
> >> >> > locking
> >> >> > file to make sure that no one else is in the system. This works fine
> >> >> > if
> >> >> > I
> >> >> > manually close any open forms before I try to run the subroutine.
> >> >> > But
> >> >> > if I
> >> >> > close forms in vba as part of my function it leaves the locking file
> >> >> > and
> >> >> > 'believes' someone else is in the system. Can someone tell me how to
> >> >> > get
> >> >> > rid
> >> >> > of the .ldb file.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>