How to repair a lost link table in a mdb which is in use

[Simon van Beek]

Dear reader,

It is possible to repair a lost linked table but in case the backend
database (mdb) is in use the process to repair the linked table process is
not working. Then the message pups up "mdb is in use".

How to link a table into an mdb which is in use by another user?

Thanks for any help.

Kind regards,

Simon

[Salad]

Simon van Beek wrote:

Dear reader,

It is possible to repair a lost linked table but in case the backend
database (mdb) is in use the process to repair the linked table process is
not working. Then the message pups up "mdb is in use".

How to link a table into an mdb which is in use by another user?

Thanks for any help.

Kind regards,

Simon

Are you doing this in code or manually via File/GetExternalData/Link?

If you need code, check out http://www.mvps.org/access/tables/tbl0009.htm

[Simon van Beek]

I am doing this in code.

"Salad" <oi*@vinegar.comwrote in message
news:uc******************************@earthlink.co m...

Simon van Beek wrote:

>Dear reader,

It is possible to repair a lost linked table but in case the backend
database (mdb) is in use the process to repair the linked table process
is not working. Then the message pups up "mdb is in use".

How to link a table into an mdb which is in use by another user?

Thanks for any help.

Kind regards,

Simon

Are you doing this in code or manually via File/GetExternalData/Link?

If you need code, check out http://www.mvps.org/access/tables/tbl0009.htm

[Marshall Barton]

Simon van Beek wrote:

>It is possible to repair a lost linked table but in case the backend
database (mdb) is in use the process to repair the linked table process is
not working. Then the message pups up "mdb is in use".

How to link a table into an mdb which is in use by another user?

You can not Compact/Repair an open database. And, because
those operations can affect every byte in the file, you
really, really need to make a verifyably good backup before
doing the repair.

You can link to a backend table by using the
TransferDatabase method (see VBA Help) or by setting a
TableDef's Connect property.

--
Marsh