Back End Paths

[gemma-the-husky]

I wondered what users do to designate a back-end path.

I tend to used an installation form within the app, that lets a user navigate to the back end, and stores the selected back end.

On opening, my apps check that the path stored is actually correct, and if not, reconnects. If the reconnect path cannot be find, then it lets the user pick a new backend with a file open save dialog.


HOWEVER, I see quite a few apps, where the paths are just set in a simple text file, which is read in, on opening - rather than provding the browse form to pick the back end.

What do most people do?

 

[Mr. B]

I typically use the method you have described for allowing the user to define the path. I normally make this a part of the Admin options as opposed to making it something that just any user would have access to.

In my opinion this is essential to delivery of any good application. First to split the applicaiton and also provide a metod for being able to set and/or change the path to the backend.

 

[Galaxiom]

Life is easy for me. All my users are on our domain which is managed by me and the guy at the next desk.

I use a hard coded drive letter mapped to a folder on a server. The mapping is done in Group Policy so can easily be moved if required.

 

[Mr. B]

Some folks just have their cake and eat it too. LOL

That's one way to make sure your paths remain valid.

 

[namliam]

I usually make it required to be in a subfolder called "database" or something

Then use currentdb.name to check for the path, my function for it is out here someplace.

 

[mcclunyboy]

Being a bit of a rookie I would like to see some of these more complex applications. obviously I understand that they are potentially commercially sensitive but if anyone has a redundant one sitting around would you mind up loading it as a sample?

The Microsoft templates are more tedious then impressive and they always seem complex when trying to replicate a feature.

 

[namliam]

A quick search of Backend on my name returns this:
http://www.access-programmers.co.uk/forums/showthread.php?t=180962&highlight=Backend

 

[dfenton]

I don't do anything. If the back end is not found for one or more linked tables, I ask the user to locate the back end using my Reconnect utility (http://dfenton.com/DFA/download/Access/Reconnect.html). I don't pre-load a path, or store a text file or write anything to the registry or anything at all. It's up to the user to know where their back end is stored.

Most of my apps have a tmp.mdb for temp data in the same folder as the front end, and I automatically reconnect that (if possible) before running my reconnect dialog.

 

[Avelino]

hi mcclunyboy

See this example

http://www.access-programmers.co.uk/forums/showthread.php?t=190194