Re: copying a backend from within frontend

"Rick Brandt" <rickbrandt2@xxxxxxxxxxx> wrote in
news:GYh2k.6650$mh5.176@xxxxxxxxxxxxxxxxxxxx:

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".

Well, not necessarily. If you can't *delete* the LDB, then it's in
use (unless you lack DELETE permission on the folder where the LDB
is stored).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: Access can-t open the database error
    ... recordsets, or there is a dangling .ldb file that Access can't get rid of. ... in order to guarantee that there will not be a permissions problem. ... works perfectly with Excel and Word interop). ...
    (microsoft.public.office.developer.automation)
  • Re: close / rename linked .mdb file
    ... TableSourceFile.mdb is there an ldb file present? ... invalidate recordsets that were opened using those links before they ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
    (microsoft.public.access.modulesdaovba)
  • Re: copying a backend from within frontend
    ... recordsets are closed. ... You can check for the presence of the LDB file in the same directory. ... RBrandt at Hunter dot com ...
    (comp.databases.ms-access)
  • Re: Compact BE while idle... so confused!
    ... back end creates the LDB file, ... The Property code ... alone would then do the trick. ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
    (comp.databases.ms-access)
  • Re: Compact BE while idle... so confused!
    ... John Mishefske wrote in ... No records will be returned but the connection (and the .LDB file) ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
    (comp.databases.ms-access)