Linking to OutLook (1 Viewer)

Good afternoon Access Commandos,

I searched the forums for an answer and there doesn't seem to be a solution that fits my needs. If there is, I apologize for not being more diligent.

I have inherited an application (Split MS Access 2010 database) that has a linked table that is linked to a shared Outlook folder. When the FE is updated, however, the table has to be relinked. Easy enough to do, but I would like to do this with VBA so the individual users do not have to.

I have searched this forum and others haven't been able to find anything that fits the bill - i.e. everything is for the default "Inbox" and/or "Contacts".

So the question(s) are:

Is it possible?
If yes, how is it done?

As always, thanks in advance!

If it's a specific table linking it back to MS Access and just a relink to the same spot then in the on_Load or on_Open event of the first form to open for the user you can put this:


Cheers!
Goh

Thanks Goh,

I will give it a shot.