By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,606 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Oct 24 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Oct 24 '08 #2

P: n/a
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

Oct 24 '08 #3

P: n/a
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
Oct 25 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.