Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   code for adding data file (http://www.outlookbanter.com/outlook-vba/100647-code-adding-data-file.html)

joe schmo March 3rd 10 05:46 PM

code for adding data file
 
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.



Ken Slovak - [MVP - Outlook] March 3rd 10 05:54 PM

code for adding data file
 
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"

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"joe schmo" wrote in message
...
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.




joe schmo March 3rd 10 07:21 PM

code for adding data file
 
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!

"Ken Slovak - [MVP - Outlook]" wrote:

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"

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"joe schmo" wrote in message
...
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.



.


Ken Slovak - [MVP - Outlook] March 3rd 10 09:20 PM

code for adding data file
 
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.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"joe schmo" wrote in message
...
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!



joe schmo March 3rd 10 11:34 PM

code for adding data file
 
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.

"Ken Slovak - [MVP - Outlook]" wrote:

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.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"joe schmo" wrote in message
...
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!


.


Ken Slovak - [MVP - Outlook] March 3rd 10 11:39 PM

code for adding data file
 
You got my strongest possible recommendation. What you do after is up to you
shrug

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"joe schmo" wrote in message
...
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.




All times are GMT +1. The time now is 11:35 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com