Relinking to back end hangs

[Ray]

I have a split DB running on a network, with code to relink to tables on
launch of the client is they are broken.

Usually, this works fine, but for some reason just hangs if another user is
using the system. Any idea why and what I can do about it?

Ray

[Trevor Best]

On Sun, 30 Nov 2003 09:37:22 +0000 (UTC) in comp.databases.ms-access,
"Ray" <ra*******@softhome.yeahright.net> wrote:

I have a split DB running on a network, with code to relink to tables on
launch of the client is they are broken.

Usually, this works fine, but for some reason just hangs if another user is
using the system. Any idea why and what I can do about it?

Hangs or just takes a long time? If in 2K or 2K2 it can take a long
time due to it disconnecting from the back end after each operation,
it then tries to delete the .ldb file from the back end, if this is
open by another user it takes a few retries before giving up.

In this case, link one table and open a form bound to it, or open the
BE database in code and hold a recordset open, in both cases, keep
that open for the duration of the app, not just the relinking as it
tries to do the same thing when closing the lats form as well.

--
A)bort, R)etry, I)nfluence with large hammer.

[Ray]

Thanks, Trevor, that's an enormous help. I'll try it out first thing
tomorrow.

Ray

"Trevor Best" <bouncer@localhost> wrote in message
news:77********************************@4ax.com...

On Sun, 30 Nov 2003 09:37:22 +0000 (UTC) in comp.databases.ms-access,
"Ray" <ra*******@softhome.yeahright.net> wrote:

I have a split DB running on a network, with code to relink to tables on
launch of the client is they are broken.

Usually, this works fine, but for some reason just hangs if another user isusing the system. Any idea why and what I can do about it?

Hangs or just takes a long time? If in 2K or 2K2 it can take a long
time due to it disconnecting from the back end after each operation,
it then tries to delete the .ldb file from the back end, if this is
open by another user it takes a few retries before giving up.

In this case, link one table and open a form bound to it, or open the
BE database in code and hold a recordset open, in both cases, keep
that open for the duration of the app, not just the relinking as it
tries to do the same thing when closing the lats form as well.

--
A)bort, R)etry, I)nfluence with large hammer.

[TC]

"Trevor Best" <bouncer@localhost> wrote in message
news:77********************************@4ax.com...

(snip)

In this case, link one table and open a form bound to it, or open the
BE database in code and hold a recordset open, in both cases, keep
that open for the duration of the app,

Or just hold the db open:

set db = dbengine.opendatabase("path to BE")

That is all it really needs :-)

TC

[Trevor Best]

On Mon, 1 Dec 2003 16:20:20 +1200 in comp.databases.ms-access, "TC"
<a@b.c.d> wrote:

Or just hold the db open:

set db = dbengine.opendatabase("path to BE")

That is all it really needs :-)

D'Oh!
;-)

--
A)bort, R)etry, I)nfluence with large hammer.