copying a backend from within frontend

[Michiel Rapati-Kekkonen]

my understanding is that you can copy a backend on condition that all
recordsets are closed.
But it is not what I experience.
Is there a way to find out what keeps the backend connected? (maybe I forgot
a recordset somewhere)

thanks for any input

Michiel

[Rick Brandt]

Michiel Rapati-Kekkonen wrote:

my understanding is that you can copy a backend on condition that all
recordsets are closed.
But it is not what I experience.
Is there a way to find out what keeps the backend connected? (maybe I
forgot a recordset somewhere)

thanks for any input

Michiel

You can check for the presence of the LDB file in the same directory. As
long as an LDB file exists then it is "in use".

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Tony Toews [MVP]]

"Michiel Rapati-Kekkonen" <[e-mail] wrote:

>my understanding is that you can copy a backend on condition that all
recordsets are closed.
But it is not what I experience.
Is there a way to find out what keeps the backend connected? (maybe I forgot
a recordset somewhere)

Recordsets can include a hidden form or reports or some such. Also a database object
if you are using such.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Albert D. Kallal]

"Michiel Rapati-Kekkonen" <[e-mail] wrote in message
news:Fq******** *******@read4.i net.fi...

my understanding is that you can copy a backend on condition that all
recordsets are closed.
But it is not what I experience.
Is there a way to find out what keeps the backend connected? (maybe I
forgot a recordset somewhere)

thanks for any input

Keep in mind that you can't call any code from a *bound* form that is
opened, that'll close all the connections.

Let me explain

form1: bound ---call forms2

form2: unbound, runs code to close form 1

You connection will stay open. Why?

it is the stack nature of objects and how ms-access cleans up it memory.

In memoory, while form1 is closed, not all of the memory is released until
the code *returns

eg:

memory form1 (and connection)
calls ----form2 (no connection
----form2 closes form1
*only* when form2 closes does the calling code + memory from form1 actually
finally get released....

So, what this means is if you manually close form1 and THEN open form2, and
then have a button on form2 that does the compact and repair, then you
should be ok. I not tried this but it possible that if form 1 called form2
via a macro (and not code), then the connection *likely* would also be
closed. It just a question when ms-access cleans up it memory...
So, if you "main" form, or startup form is un-bound, then you should be
able to place a button on that main form that does the compact and repair.
And even better way is to put a option in a custom menu bar, and have that
call code in a module. (this module code can close all forms, and since
there is no program stack called *from* that forms...there is not return
stack..and thus the connections are released).

at
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com

[lyle fairfield]

How are you copying?

Using the Windows Explorer Interface one can copy and paste
"Northwinds 2007,accdb" whether or not there is a recordset open,
whether or not a lock file exists, and also, surprisingly, perhaps,
whether or not Northwinds 2007,accdb is opened exclusively. TTBOMK
this is true for all Access files, including MDB files.

If you are copying with code, then we should see the code.

On Jun 6, 2:34*pm, "Michiel Rapati-Kekkonen" <n...@nonsense. zzwrote:

my understanding is that you can copy a backend on condition that all
recordsets are closed.
But it is not what I experience.
Is there a way to find out what keeps the backend connected? (maybe I forgot
a recordset somewhere)

thanks for any input

Michiel

[Michiel Rapati-Kekkonen]

Thank you all for your splendid insights
I could combine quite a lot of it into my solution.

maybe you're also interested why I wanted it:
it is because I have to experiment with the data (a testcopy of course)
so after some experiments I need the original, fresh data again.

My startupform is unbound, but for some reason the ldb stays alive when it
is not closed.
so from the startupform I open another form, where I can close the
startupform,
then do a while-wend, checking if the ldb is still there (it takes a few
seconds),
do the copy of the data and finally open the startupform again.

I'm happy.
Thank you all

Michiel

"Michiel Rapati-Kekkonen" <[e-mail] wrote in message
news:Fq******** *******@read4.i net.fi...

my understanding is that you can copy a backend on condition that all
recordsets are closed.
But it is not what I experience.
Is there a way to find out what keeps the backend connected? (maybe I
forgot a recordset somewhere)

thanks for any input

Michiel

[lyle fairfield]

You may be happy, but millions of others would want a database that
worked properly. What you describe is idiocy.

On Jun 7, 8:40*am, "Michiel Rapati-Kekkonen" <n...@nonsense. zzwrote:

My startupform is unbound, but for some reason the ldb stays alive when it
is not closed.
so from the startupform I open another form, where I can close the
startupform,
then do a while-wend, checking if the ldb is still there (it takes a few
seconds),
do the copy of the data and finally open the startupform again.

I'm happy.

[Michiel Rapati-Kekkonen]

you're not always polite
"lyle fairfield" <ly************ @gmail.comwrote in message
news:e9******** *************** ***********@c65 g2000hsa.google groups.com...
You may be happy, but millions of others would want a database that
worked properly. What you describe is idiocy.

On Jun 7, 8:40 am, "Michiel Rapati-Kekkonen" <n...@nonsense. zzwrote:

My startupform is unbound, but for some reason the ldb stays alive when it
is not closed.
so from the startupform I open another form, where I can close the
startupform,
then do a while-wend, checking if the ldb is still there (it takes a few
seconds),
do the copy of the data and finally open the startupform again.

I'm happy.

[Tony Toews [MVP]]

"Michiel Rapati-Kekkonen" <[e-mail] wrote:

>My startupform is unbound, but for some reason the ldb stays alive when it
is not closed.

Just to double check that the problem is in the startup form. What happens when you
manually close the form? Does the LDB file go away? If so then problem is in that
form. Now maybe there's a combo box or list box on that form against a table? Or
some code opening the database or a table.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Michiel Rapati-Kekkonen]

yes, you are and were right: the combo box was unbound, but it rowsource
queried a table.
thanks

michiel

"Tony Toews [MVP]" <tt****@teluspl anet.netwrote in message
news:jt******** *************** *********@4ax.c om...

"Michiel Rapati-Kekkonen" <[e-mail] wrote:

>>My startupform is unbound, but for some reason the ldb stays alive when it
is not closed.

Just to double check that the problem is in the startup form. What
happens when you
manually close the form? Does the LDB file go away? If so then problem
is in that
form. Now maybe there's a combo box or list box on that form against a
table? Or
some code opening the database or a table.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/