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