Changing your Access database directory?

[TerraEarth]

If I decide to place my access database file in another location, I would have to also change numerous filePaths used in my code to fit the new directory location.

This is because in my access database, several files/folders are referenced within my database folder (the folder containing my access database).

Is there an elegant way of handling this? I was thinking of two solutions:



1) Have a table with a single value, single field that indicates the filepath to be used and all modules that use file paths in their code will reference this new table for the current value of the directory.

2) Standardize all file paths to point to a generic drive (the C:/ drive for example) and leave an instruction to always place the file in that particular drive on their PCs.

Any suggestions?

[davegri]

http://jrsoftware.org/isinfo.php
Check out this link. I used inno a few years ago to install Access applications. As I recall, it will set up any directory structure you need on the target computer.

[Gicu]

Just use CurrentProject.Path in your code to get the path of the front-end (folder) or CurrentProject.FullName to include the name of the front-end file.

Cheers,
Vlad

[TerraEarth]

Just use CurrentProject.Path in your code to get the path of the front-end (folder) or CurrentProject.FullName to include the name of the front-end file.

This is wild.

[Gicu]

Like in "it works" ?

[TerraEarth]

As in "I want off this ride but the brakes tore off yesterday."

[davegri]

I don't want to be the bad boy here, but this needs to be said.
TerraEatth, show some respect for those why try to help you, especially those that solve your problems or spend considerable time investigating a solution.
Gicu suggested a solution. Your response: "This is wild". That conveyed NO intelligence on whether it helped you or not.
So, Gicu asked you directly if it helped. Your response was "I want off this ride but the brakes tore off yesterday."
TerraEarth, this behavior is a fast way to get on the forum user's Ignore List. Gicu might be reluctant to respond to any of your future posts (as might I and others).

A more appropriate response would be to either point out that the suggestion did not help because...
or THANK YOU!

[Gicu]

Thanks davegri!

Vlad

[TerraEarth]

Maybe I should elaborate.

When I said "this is wild" this was me expressing my excitement at discovering a solution provided by another user. It was a very simple solution and yet it directly solved the issue I was facing and I found it to be rather cool in that sense or in another phrase - wild. I marked the thread as solved immediately after the response. I don't think Gicu took offense to my response, but if he did I want to say that I meant no offense and that he did indeed helped me. The "I want off this ride but the brakes tore off yesterday." was meant to be a humorous response indicating how blown away I was - as if I was on a ride with no brakes!

I don't feel as if I'm entitled to responses and if you or anyone else feels for whatever reason that they never want to respond to my threads ever again - I am okay with that. I do think that this forum and its constituent users are very helpful. Thank you all!