Environment Variables in Access 97 Link Path

  • Thread starter Thread starter John
  • Start date Start date
J

John

Dear Group,
I am still new to Access and need a little help. I have been told by
other developers that it may be possible to put an Environment Variable in a
Link Path for Access that would allow the admin of a user's machine to
determine the location for a file that needs to be linked in.

While I don't quite understand, I am hopping someone here does and can
help. Thanks.

John.
 
Larry,
Thanks for the example, but it does not answer may problem.

I need to setup the actual links in Access 97 to use an Environment
variable for their path.

John.
 
Note: this is an Operating System function, not an Access function:

Open a DOS session and type

SET EnvironmentVariableName=Value

HTH
 
The actual links are static and are resolved at link time.
If you do the linking in code, you can use the vba.Environ
function to get part or all of your link string value, as:

tdf.Connect = Environ("link_1")
 
John said:
I am still new to Access and need a little help. I have been told by
other developers that it may be possible to put an Environment Variable in a
Link Path for Access that would allow the admin of a user's machine to
determine the location for a file that needs to be linked in.
Click to expand...

I'm not sure what Environment Variables have to do with your
objective. The following should help.

Retrieve linked database namepath
http://www.mvps.org/access/tables/tbl0007.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top