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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Simon van Beek
    #1

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

    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


    Tags: None
    • Salad
      #2
      Re: How to repair a lost link table in a mdb which is in use

      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

        Comment

        • Simon van Beek
          #3
          Re: How to repair a lost link table in a mdb which is in use

          I am doing this in code.

          "Salad" <oil@vinegar.co mwrote in message
          news:uc-dnXM8yu603Z_UnZ 2dnUVZ_gSdnZ2d@ earthlink.com.. .
          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

            Comment

            • Marshall Barton
              #4
              Re: How to repair a lost link table in a mdb which is in use

              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
              TransferDatabas e method (see VBA Help) or by setting a
              TableDef's Connect property.

              --
              Marsh

                Comment

                Previous template Next
                Working...