How to create a .pst file automatically when a record is created in MS Access DB.

Question

How could I create a .pst file automatically when a record is created in an MS Access DB?

---

Nath

Answer 1

Hi Nath,

I haven't tried it but you might be able to Automate Outlook to create a PST file from Access.

Good luck!

Answer 2

See the below link:

http://www.outlookcode.com/codedetail.aspx?id=84

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Answer 3

Hi Nath,

Has your issue been resolved?

For this requirement, you could try Table After Insert event to run a data macro, in data macro you could run VBA code which will create the pst file.

For creating pst file, you could refer below link.

# AddStoreEx Method

https://msdn.microsoft.com/en-us/library/office/aa219415%28v=office.11%29.aspx?f=255&MSPPError=-2147217396

Best Regards,

Edward

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].