Programming the BackEnd path

[James3mc]

I'm developing a FrontEnd/BackEnd application for a school.

Naturally the path to their version of the BackEnd is different to the path on my development laptop.

How do i tell the FrontEnd where to look for the BackEnd? If i just give them my copy of Front + Back, then the Linked table manager is looking a path that only exists on my machine.

[RuralGuy]

Here's a link to a good solution. http://www.mvps.org/access/tables/tbl0009.htm

[James3mc]

I think there must be a couple of functions missing from that code, namely the underlined :

strFilter = ahtAddFilterItem(strFilter, _
                    "Access Database(*.mdb;*.mda;*.mde;*.mdw) ", _
                    "*.mdb; *.mda; *.mde; *.mdw")

and

fGetMDBName = ahtCommonFileOpenSave(Filter:=strFilter, _
                                OpenFile:=True, _
                                DialogTitle:=strIn, _
                                Flags:=ahtOFN_HIDEREADONLY)

because i get compiler errors.

Also i'm not really sure that's what i want. I simply want to specify a different path (to the backend) depending on whether it's my laptop or the "client's" desktop pc that it's running on.

[RuralGuy]

The link stated you need to have this code as well:
http://www.mvps.org/access/api/api0001.htm

[James3mc]

Ah no, that's not what i want. But thanks for the link though.

So can anyone suggest a way to do this? I simply want a way for the Front End to pick up the Back End from a different location if it's running on the client's machine rather than my own.

[RuralGuy]

The links I pointed to either refreshes the current links or if the BackEnd is not found, bring up a form that allows the user to locate the BackEnd, and then refresh the links. Unless you hard code the links I doubt you could get a much more flexible or simple solution.

[Rainlover]

There is a Dos Command that might help.

First Create a Folder on your C:\Drive and name it with the Letter of the Drive that your Client uses.

eg R

Then run this command.

SUBST R: C:\R

This will create a Virtual Drive on your machine which you can Link to. Then when you send the client an update the Fornt End is already linked to the correct Drive letter.

In my example I am assuming your Client stores the back end on the R:\Drive.