rmt db

[alxw3 via AccessMonster.com]

my front end main form application button executes Me.get_dt_query.Form.
RecordSource = cmdSql
and Me.get_dt_query.Form.Requery to update a subform. this keep the
connection up. I notice lock db file created on remote location. How to
disconnect from remote db after each query so that lock db file disappears.

 

[MGFoster]

my front end main form application button executes Me.get_dt_query.Form.
RecordSource = cmdSql
and Me.get_dt_query.Form.Requery to update a subform. this keep the
connection up. I notice lock db file created on remote location. How to
disconnect from remote db after each query so that lock db file disappears.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The lock file (.ldb) stays open while you are connected to the db file.
It doesn't have to close after the query. Once everyone signs out of
the db the .ldb file is supposed to disappear.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSidMv4echKqOuFEgEQKPzwCg8brTgR3nkvibjZmx0bgHLu9esI8An0su
lSwcS7qd1NeNjsRcmBk/4vC4
=TByR
-----END PGP SIGNATURE-----