Welcome to SPN

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

Sign Up Now!

links relative path

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

  1. bobdydd

    bobdydd
    Expand Collapse
    Guest

    Hi Everybody

    Access 2000, Windows XP

    I have an Access Database on a stand alone Machine with a
    Frontend/Backend:

    I send it to users with an install routine that installs like this:

    C:\MyFolder\MyProgram\MyFrontend.mde
    C:\MyFolder\MyProgram\MyBackend.mdb

    Works OK until someone moves it to their "D" or "E" drive.

    Then it loses the connection and although I have a form to re-find the
    backend I would rather have the connection/linking always find the
    Backend, no matter where the folder containing the 2 databases
    are...........which will always be in the same folder.

    I have seen this code by Peter Vucovic
    http://allenbrowne.com/ser-13.html
    but it does not seem to respond...been written circa 1995 for Access
    2...

    Thanks in advance

    Bob
     
  2. Loading...

    Similar Threads Forum Date
    India Indian sting busts up $130-million drug and money laundering ring-Links to Canada Breaking News Jan 31, 2013
    News Links to Doctored Video that Framed Professor Darshan Singh Now Exposed (Khalsa News) Punjab, Punjabi, Punjabiyat Dec 17, 2011
    World UN links Iran to nuclear weapons Breaking News Nov 9, 2011
    Learn Punjabi Looking for a Few Good Links to Learn Gurmukhi Language, Arts & Culture Aug 8, 2011
    Emotional Links to Genetic Health: Biological Heaven and Hell Interfaith Dialogues Mar 4, 2011

  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    That's using DAO. Access 2000 doesn't have a reference to DAO by default.

    Open the VB Editor, select Tools | References from the menu bar, scroll
    through the list of available references until you find the one for
    Microsoft DAO 3.6 Object Library, and select it.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "bobdydd" <reallyuseful2004@yahoo.co.uk> wrote in message
    news:1150229590.301803.279760@u72g2000cwu.googlegroups.com...
    > Hi Everybody
    >
    > Access 2000, Windows XP
    >
    > I have an Access Database on a stand alone Machine with a
    > Frontend/Backend:
    >
    > I send it to users with an install routine that installs like this:
    >
    > C:\MyFolder\MyProgram\MyFrontend.mde
    > C:\MyFolder\MyProgram\MyBackend.mdb
    >
    > Works OK until someone moves it to their "D" or "E" drive.
    >
    > Then it loses the connection and although I have a form to re-find the
    > backend I would rather have the connection/linking always find the
    > Backend, no matter where the folder containing the 2 databases
    > are...........which will always be in the same folder.
    >
    > I have seen this code by Peter Vucovic
    > http://allenbrowne.com/ser-13.html
    > but it does not seem to respond...been written circa 1995 for Access
    > 2...
    >
    > Thanks in advance
    >
    > Bob
    >
     
  4. bobdydd

    bobdydd
    Expand Collapse
    Guest

    Thanks Doug

    That did the trick..............Once again I owe you

    Thanks


    Douglas J. Steele wrote:
    > That's using DAO. Access 2000 doesn't have a reference to DAO by default.
    >
    > Open the VB Editor, select Tools | References from the menu bar, scroll
    > through the list of available references until you find the one for
    > Microsoft DAO 3.6 Object Library, and select it.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no private e-mails, please)
    >
    >
    > "bobdydd" <reallyuseful2004@yahoo.co.uk> wrote in message
    > news:1150229590.301803.279760@u72g2000cwu.googlegroups.com...
    > > Hi Everybody
    > >
    > > Access 2000, Windows XP
    > >
    > > I have an Access Database on a stand alone Machine with a
    > > Frontend/Backend:
    > >
    > > I send it to users with an install routine that installs like this:
    > >
    > > C:\MyFolder\MyProgram\MyFrontend.mde
    > > C:\MyFolder\MyProgram\MyBackend.mdb
    > >
    > > Works OK until someone moves it to their "D" or "E" drive.
    > >
    > > Then it loses the connection and although I have a form to re-find the
    > > backend I would rather have the connection/linking always find the
    > > Backend, no matter where the folder containing the 2 databases
    > > are...........which will always be in the same folder.
    > >
    > > I have seen this code by Peter Vucovic
    > > http://allenbrowne.com/ser-13.html
    > > but it does not seem to respond...been written circa 1995 for Access
    > > 2...
    > >
    > > Thanks in advance
    > >
    > > Bob
    > >
     

Share This Page