XP & Vista & Win 7 My Doc Directory Structure.

[Paul Shapiro]

So you're saying the users can attach any file, from any folder? If so, it
would seem to be up to the user to keep them in the same place.

For bulk moves, like you described for changing the OS, you could give them
a command button to let them choose a new location for an existing file.
Once they've selected the new location, you could ask if they want you to
update the saved location for all files in the original folder. As part of
making that update, I would probably verify that the referenced files exist.

You could also give them a command button to verify all files, and prompt
for new locations and/or reference deletion for any missing files, etc.

Or, if this is really a one-time change, you could write a query to make the
appropriate update to all file references. While this is a pain, I'd guess
it will be some time before the \Users folder gets renamed again.

 

[Dennis]

Paul,

I see you point. Rather than treat this as a database issue, treat it as a
conversion issue, which it really is. Hmm, had not though about it from
that point of view.



Your comment "So you're saying the users can attach any file, from any
folder? If so, it would seem to be up to the user to keep them in the same
place."

Response: Converted to Window's & has caused me to re-think this issue.
I'm thinking about re-writing the code to copy the document to my own
directory where I can manage them and don't have to worry about the user
moving them or deleteing them.




Thanks,

Dennis

 

[Dennis]

David,

Thanks for you input. I will be making that change.

Dennis

 

[chloe bejar]

Hi,

I just want to ask if the issue I'm facing right now is the same as your problem.

My Case:
When clicking a function, let's say a backup operation, an open dialog will popup pointing to the application path. Ex: C:\Chloe\Backup

This works when I'm in a WinXP OS, but when using a Win7 OS what happens is the popup will open pointing to a different path. Ex: Libraries\Documents.

Can this be fixed using the roaming profile and folder redirection?

Thanks,
Chloe

Hi,

I am developing using Access XP Office on Windows 7. My users are running
Access XP and Access 2007 on Widows XP, Vista, and Windows 7.

I not quite in which forum this question belongs, but since it came up in a
form, I am asking the question in this forum.

I have "blob" type files (.tiff, .jpg, etc.) that were stored in different
sub-directories under C:\Documents and Settings\<User Name>\My
Documents\....." Rather than store the file in the database, I store the
full path and file name in my database.

As you know MS, "in their infinite wisdom" , decided to change the
"Document" directory structure on Vista and Windows 7 to "C:\Users\<User
Name>\Documents\....".

Fortunately, the first user to when to Vista had not used the "blob" files
very much, but they had a few. So I had to go in by hand and change the path
names. However, it did point out a flaw in how I am storing the path name.

I need to change how I store my path names so I do not have to manually
convert them (or write code to convert them) when other users upgrade to
Vista or Windows 7.

Any suggestions?

Do I have to parce the path name and store it in pieces so that I can
reassemble the correct file name name depending upon which OS I am on or is
there a better way.

Thanks,


Dennis

\Documents
and Settings\<User Name>\My Documents\....." under XP: for instance, on my
XP machine, my My Documents folder is located on the D drive.

Use the SHGetSpecialFolderLocation API, as outlined in
http://www.mvps.org/access/api/api0054.htm at "The Access Web". The
specific invocation you will want is fGetSpecialFolderLocation(CSIDL_PERSONAL)

//www.mvps.org/access/api/api0003.htm[/URL] at "The Access
Web" for information about determining the details about mapped drives.