Locking and Transferdatabase

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

    Locking and Transferdatabase

    Hi all,
    I am trying to use transferdatabas e to link tables to a shared backend.
    If someone is already using the back end, transferdatabas e tries to
    lock the table and causes an error. Is there another way to control
    locking on transferdatabas e since no data is in question? Is there
    any other way to link tables other than ADOX?
    Thanks
    Pachydermitis
    Tags: None
    • TC
      #2
      Re: Locking and Transferdatabas e

      You can link tables using DAO (and VBA). Check out online help for the DAO
      Connect property. You should be able to find some examples, from there.

      HTH,
      TC


      "Pachydermi tis" <dedejavu@hotma il.com> wrote in message
      news:4f954dcf.0 401201748.79657 3f0@posting.goo gle.com...[color=blue]
      > Hi all,
      > I am trying to use transferdatabas e to link tables to a shared backend.
      > If someone is already using the back end, transferdatabas e tries to
      > lock the table and causes an error. Is there another way to control
      > locking on transferdatabas e since no data is in question? Is there
      > any other way to link tables other than ADOX?
      > Thanks
      > Pachydermitis[/color]


        Comment

        • Pachydermitis
          #3
          Re: Locking and Transferdatabas e

          Thanks. I'm trying to avoid DAO as it is causing the problems I'm having.

          "TC" <a@b.c.d> wrote in message news:<107466217 2.596098@teutho s>...[color=blue]
          > You can link tables using DAO (and VBA). Check out online help for the DAO
          > Connect property. You should be able to find some examples, from there.
          >
          > HTH,
          > TC
          >
          >
          > "Pachydermi tis" <dedejavu@hotma il.com> wrote in message
          > news:4f954dcf.0 401201748.79657 3f0@posting.goo gle.com...[color=green]
          > > Hi all,
          > > I am trying to use transferdatabas e to link tables to a shared backend.
          > > If someone is already using the back end, transferdatabas e tries to
          > > lock the table and causes an error. Is there another way to control
          > > locking on transferdatabas e since no data is in question? Is there
          > > any other way to link tables other than ADOX?
          > > Thanks
          > > Pachydermitis[/color][/color]

            Comment

            Previous template Next
            Working...