Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
    > >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page