code for adding data file

  • Thread starter Thread starter joe schmo
  • Start date Start date
J

joe schmo

I would like to make a macro that would add a data file. Is this possible?
Lets say the file name is archive.pst located in G:\temp. thanks very much

I want to do this because I want the user to be able to access the data
files while at work (data files on server), and not get the 'cannot access
data file' error when she goes home and opens outlook.
 
You do know that storing and using PST files stored anywhere but on a local
hard drive is not supported, may lead to problems and data corruption and
loss or locking or corruption of the PST and that no one will support you if
things go wrong, correct?

If a PST file is opened in Outlook and the user then goes to where that file
is not accessible what makes you think they will be able to use the file
then? Outlook will just show an error that it cannot load the file.

The code itself is simple, assuming you are using an Outlook version that
supports this, you never mentioned your version:

Application.Session.AddStore "G:\temp\archive.pst"
 
Actually we all have archive pst files on a server. This is to reduce the
working copy in exchange. we are using outlook 2003 and 07. I just want
the user to not see the archives when she goes home with laptop, and then see
them when she comes into work (server accessible). I'm pretty sure this is
supported though....standard procedure no?

otherwise, I'll work with your code, thanks!
 
No, it's absolutely not supported at all. PST files anywhere other than on a
local hard drive are totally unsupported. I would strongly recommend against
what you plan and how you store the archive PST's.

If you add a PST file, either in the UI or in code, it will be there in
Outlook and show up until Outlook is closed. If it was removed prior to
closing Outlook it won't show up or fire errors starting Outlook if the PST
isn't available. If it is not removed prior to shutdown there will be errors
if the PST is not available.

There is a RemoveStore() method that takes a file path, but the user would
have to run that code before shutting down Outlook.

If something in this causes corruption, data loss or the inability to open
the PST file don't be surprised and don't expect anyone to help you. Expect
any MVP to tell you that what you did was unsupported. If you still want to
do this you're on your own.
 
thanks for the reply. Seems like I got you on a bad day though. Please
understand that your role is to advise and recommend, not to accuse and
berate. Hope tomorrow is a better day for you.
till next time.
 
You got my strongest possible recommendation. What you do after is up to you
<shrug>
 
Back
Top