Office Links option

[Robert Ross]

Our company is trying to help contain potential problems
when using the Office Links feature.

When you open a table/query and you click Tools, Office
Links and any option from there (Merge it with Word,
Publish it with Word or Analyze it with Excel), a new file
is created in the appropriate format (.doc or .xls) but it
is created in the path listed as the default file location
for Excel. For instance, if your default file location is
C:\Documents and Settings\EDFUND\My Documents (as is the
default location when you click Tools, Options, General
and look at the bottom right) and you click Analyze it
with Excel, an Excel file is created in that location.

For any company with sensitive information, this can be
disastrous if a laptop is lost that contains vital data
and the user has run the Office Links tool.

To mitigate this, we'd like to find out where this data is
located in the registry so we can create a key to change
this path to one that's on our secure network.

Does anyone know the Registry Key that holds the default
file location for MSAccess? If anyone knows the key for
Word and Excel, that would be great for other security-
concious people out there as well.

THX!

 

[Col]

Hi Robert

You can try
str_AccessDir = SysCmd(acSysCmdAccessDir)

Regards

Colin

 

[Rib]

Colin,

I'm not sure what you mean...where would I put that line?

I'm more concerned with databases that are not created by
me or my staff...'homegrown' databases. If the line you
provided me is database specific, it won't protect us from
the homegrown DB's, since users will not know where to put
that line (same as I don't know).

I need to find the Registry Key that sets the path so I
can force systems to a protected path on log in. I'm
thinking I can still use the code you gave me to force my
own DB's to use that path (in case they try to switch the
default file path after logging in). I'm guessing my line
would look like this:?

str_AccessDir = SysCmd(f:\officelinks)

Is that the proper syntax? And where would I place this
line of code?

THX