Using Wild Card Characters for Report Location

  • Thread starter Thread starter TheScullster
  • Start date Start date
T

TheScullster

Hi all

We have an Access 2000 split database with a bit of VB code developed by
"others".
The problem is, moving from Win98 to XP has caused us some permission
issues.
One of these is the way reports are written to c:\ drive folders, which
regular users don't have permission to use by default.

Currently, the report output code includes text as follows:

"C:\My Documents\Temp.rtf"

How do I allow for placement in the Documents and Settings for that
particular user, rather than writing to either the c:\ router directory or
another inaccessible folder (I am reluctant to give each user unlimited
access to their c:\ drives.

TIA

Phil
 
Use the API to get the Special Folders location for the logged in user:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnima01/html/ima0187.asp

--
Troy

Troy Munford
Development Operations Manager
FMS, Inc.
www.fmsinc.com


"TheScullster" <phil-at-dropthespam.com> wrote in message
Hi all

We have an Access 2000 split database with a bit of VB code developed by
"others".
The problem is, moving from Win98 to XP has caused us some permission
issues.
One of these is the way reports are written to c:\ drive folders, which
regular users don't have permission to use by default.

Currently, the report output code includes text as follows:

"C:\My Documents\Temp.rtf"

How do I allow for placement in the Documents and Settings for that
particular user, rather than writing to either the c:\ router directory or
another inaccessible folder (I am reluctant to give each user unlimited
access to their c:\ drives.

TIA

Phil
 
Thanks for that Troy

It all looks a bit technical for my tiny brain.
Guess I'll take the coward's way out and change the coded paths.
Problem is that XP controls access to local folders, so it's a case of
adding the folder to each machine and setting permissions (yawn)

Thanks again

Phil
 
Back
Top