Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Losing the path

Discussion in 'Information Technology' started by Tom, Jul 28, 2006.

Tags:
  1. Tom

    Tom
    Expand Collapse
    Guest

    Hi,

    I have few dap in my DB.
    the path for the data is C:\myprject\myproject.mdb
    when I copy the files to a different machine I lose the connection to the
    data, even if I keep all the files in the same path.

    Any suggestions?

    Thanks,

    Tom
     
  2. Loading...

    Similar Threads Forum Date
    Feeling Like I'm Losing "it" Blogs Jul 8, 2016
    The Sorrow Of Losing Something I Never Had Hard Talk Jan 30, 2016
    Questioning/Losing Faith... Questions and Answers May 5, 2014
    Christianity Losing My Religion: Why I'm Raising My Child To Believe In Science, Not God Interfaith Dialogues May 21, 2013
    India Badals afraid of losing Sehajdhari case: Dr Ranu Breaking News Oct 30, 2012

  3. Delordson Kallon

    Delordson Kallon
    Expand Collapse
    Guest

    Hi Tom,

    If your tables (i.e. the backend) is in a separate database from your forms
    (the frontend), then after you copy the databases to a new machine, go to the
    frontend database and relink the tables.

    Delordson Kallon
    www.instantsoftwaretraining.com


    "Tom" wrote:

    > Hi,
    >
    > I have few dap in my DB.
    > the path for the data is C:\myprject\myproject.mdb
    > when I copy the files to a different machine I lose the connection to the
    > data, even if I keep all the files in the same path.
    >
    > Any suggestions?
    >
    > Thanks,
    >
    > Tom
    >
    >
    >
    >
     
  4. Tom

    Tom
    Expand Collapse
    Guest

    Thanks for your response,
    I was wondering why is the path gone even if it`s the same path, and if it
    possible to eliminate the relink step?

    Thanks,
    Tom
    "Delordson Kallon" <DelordsonKallon@discussions.microsoft.com> wrote in
    message news:531F2F8D-4774-4E4D-82BA-CC01B0B01CB9@microsoft.com...
    > Hi Tom,
    >
    > If your tables (i.e. the backend) is in a separate database from your
    > forms
    > (the frontend), then after you copy the databases to a new machine, go to
    > the
    > frontend database and relink the tables.
    >
    > Delordson Kallon
    > www.instantsoftwaretraining.com
    >
    >
    > "Tom" wrote:
    >
    >> Hi,
    >>
    >> I have few dap in my DB.
    >> the path for the data is C:\myprject\myproject.mdb
    >> when I copy the files to a different machine I lose the connection to the
    >> data, even if I keep all the files in the same path.
    >>
    >> Any suggestions?
    >>
    >> Thanks,
    >>
    >> Tom
    >>
    >>
    >>
    >>
     
  5. Delordson Kallon

    Delordson Kallon
    Expand Collapse
    Guest

    Hi Tom,

    I can't say I know for sure that what you have is a relinking problem but
    that's my best guess. (If I'm on the wrong track here maybe someone can jump
    in and put us both straight?). If this is the problem then you can use some
    code to relink the tables the first time the database is opened. Something
    like:

    DoCmd.TransferDatabase acLink, "Microsoft Access",
    "C:\myprject\myproject.mdb", acTable, "SourceTableName",
    "DestinationTableName"

    Replace SourceTableName and DestinationTableName with the names of the
    tables in you back and front ends. These may well be the same. You will need
    to do this for every table in your backend.

    Delordson Kallon
    www.instantsoftwaretraining.com

    "Tom" wrote:

    > Thanks for your response,
    > I was wondering why is the path gone even if it`s the same path, and if it
    > possible to eliminate the relink step?
    >
    > Thanks,
    > Tom
    > "Delordson Kallon" <DelordsonKallon@discussions.microsoft.com> wrote in
    > message news:531F2F8D-4774-4E4D-82BA-CC01B0B01CB9@microsoft.com...
    > > Hi Tom,
    > >
    > > If your tables (i.e. the backend) is in a separate database from your
    > > forms
    > > (the frontend), then after you copy the databases to a new machine, go to
    > > the
    > > frontend database and relink the tables.
    > >
    > > Delordson Kallon
    > > www.instantsoftwaretraining.com
    > >
    > >
    > > "Tom" wrote:
    > >
    > >> Hi,
    > >>
    > >> I have few dap in my DB.
    > >> the path for the data is C:\myprject\myproject.mdb
    > >> when I copy the files to a different machine I lose the connection to the
    > >> data, even if I keep all the files in the same path.
    > >>
    > >> Any suggestions?
    > >>
    > >> Thanks,
    > >>
    > >> Tom
    > >>
    > >>
    > >>
    > >>

    >
    >
    >
     
  6. Tom

    Tom
    Expand Collapse
    Guest

    Thanks for your input. that code sounds promising, but wher Do I put it?
    in the onOpen event of the first form?

    Tom
    "Delordson Kallon" <DelordsonKallon@discussions.microsoft.com> wrote in
    message news:55DAD6C1-2D8F-4FC7-AB8C-40C72FAF97A9@microsoft.com...
    > Hi Tom,
    >
    > I can't say I know for sure that what you have is a relinking problem but
    > that's my best guess. (If I'm on the wrong track here maybe someone can
    > jump
    > in and put us both straight?). If this is the problem then you can use
    > some
    > code to relink the tables the first time the database is opened. Something
    > like:
    >
    > DoCmd.TransferDatabase acLink, "Microsoft Access",
    > "C:\myprject\myproject.mdb", acTable, "SourceTableName",
    > "DestinationTableName"
    >
    > Replace SourceTableName and DestinationTableName with the names of the
    > tables in you back and front ends. These may well be the same. You will
    > need
    > to do this for every table in your backend.
    >
    > Delordson Kallon
    > www.instantsoftwaretraining.com
    >
    > "Tom" wrote:
    >
    >> Thanks for your response,
    >> I was wondering why is the path gone even if it`s the same path, and if
    >> it
    >> possible to eliminate the relink step?
    >>
    >> Thanks,
    >> Tom
    >> "Delordson Kallon" <DelordsonKallon@discussions.microsoft.com> wrote in
    >> message news:531F2F8D-4774-4E4D-82BA-CC01B0B01CB9@microsoft.com...
    >> > Hi Tom,
    >> >
    >> > If your tables (i.e. the backend) is in a separate database from your
    >> > forms
    >> > (the frontend), then after you copy the databases to a new machine, go
    >> > to
    >> > the
    >> > frontend database and relink the tables.
    >> >
    >> > Delordson Kallon
    >> > www.instantsoftwaretraining.com
    >> >
    >> >
    >> > "Tom" wrote:
    >> >
    >> >> Hi,
    >> >>
    >> >> I have few dap in my DB.
    >> >> the path for the data is C:\myprject\myproject.mdb
    >> >> when I copy the files to a different machine I lose the connection to
    >> >> the
    >> >> data, even if I keep all the files in the same path.
    >> >>
    >> >> Any suggestions?
    >> >>
    >> >> Thanks,
    >> >>
    >> >> Tom
    >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     
  7. Delordson Kallon

    Delordson Kallon
    Expand Collapse
    Guest

    The OnOpen event of the first form sounds like the right place. You may want
    to first check that the links are not already established.

    i.e.

    Check if tables already correctly linked
    if not, relink
    if they are, do nothing.

    There may be better ways to check if your tables are correctly linked but
    one method that has always worked for me is to attempt to create a recordset
    with one of the tables. If I get an error, I run the relink code.

    Dim rst as Recordset
    Set rst = CurrentDb.OpenRecordset("AnyTable")

    ' If there is an error, relink.
    If Err <> 0 Then
    call RelinkTables()
    End If


    Delordson Kallon
    www.instantsoftwaretraining.com


    "Tom" wrote:

    > Thanks for your input. that code sounds promising, but wher Do I put it?
    > in the onOpen event of the first form?
    >
    > Tom
    > "Delordson Kallon" <DelordsonKallon@discussions.microsoft.com> wrote in
    > message news:55DAD6C1-2D8F-4FC7-AB8C-40C72FAF97A9@microsoft.com...
    > > Hi Tom,
    > >
    > > I can't say I know for sure that what you have is a relinking problem but
    > > that's my best guess. (If I'm on the wrong track here maybe someone can
    > > jump
    > > in and put us both straight?). If this is the problem then you can use
    > > some
    > > code to relink the tables the first time the database is opened. Something
    > > like:
    > >
    > > DoCmd.TransferDatabase acLink, "Microsoft Access",
    > > "C:\myprject\myproject.mdb", acTable, "SourceTableName",
    > > "DestinationTableName"
    > >
    > > Replace SourceTableName and DestinationTableName with the names of the
    > > tables in you back and front ends. These may well be the same. You will
    > > need
    > > to do this for every table in your backend.
    > >
    > > Delordson Kallon
    > > www.instantsoftwaretraining.com
    > >
    > > "Tom" wrote:
    > >
    > >> Thanks for your response,
    > >> I was wondering why is the path gone even if it`s the same path, and if
    > >> it
    > >> possible to eliminate the relink step?
    > >>
    > >> Thanks,
    > >> Tom
    > >> "Delordson Kallon" <DelordsonKallon@discussions.microsoft.com> wrote in
    > >> message news:531F2F8D-4774-4E4D-82BA-CC01B0B01CB9@microsoft.com...
    > >> > Hi Tom,
    > >> >
    > >> > If your tables (i.e. the backend) is in a separate database from your
    > >> > forms
    > >> > (the frontend), then after you copy the databases to a new machine, go
    > >> > to
    > >> > the
    > >> > frontend database and relink the tables.
    > >> >
    > >> > Delordson Kallon
    > >> > www.instantsoftwaretraining.com
    > >> >
    > >> >
    > >> > "Tom" wrote:
    > >> >
    > >> >> Hi,
    > >> >>
    > >> >> I have few dap in my DB.
    > >> >> the path for the data is C:\myprject\myproject.mdb
    > >> >> when I copy the files to a different machine I lose the connection to
    > >> >> the
    > >> >> data, even if I keep all the files in the same path.
    > >> >>
    > >> >> Any suggestions?
    > >> >>
    > >> >> Thanks,
    > >> >>
    > >> >> Tom
    > >> >>
    > >> >>
    > >> >>
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >
     

Share This Page