links relative path

[bobdydd]

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

 

[Douglas J. Steele]

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.

 

[bobdydd]

Thanks Doug

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

Thanks