I have imported data from my Access database into my Calendar. However my database is regulary updated I do not want to keep importing the data every time I update the database, I would like to synchronise the database with my Calendar is it possible? The database is stored on my main file server.

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

1. Manual
Download the field98.exe patch from Microsoft. This adds the ability to map fields from access into your contacts Folder in the import - export wizard.

2. Automatic
I have employed this method to keep a contacts folder in line with an Access db containing contact info.

a. First look at MS article q180981. This gives sample code for importing access db's into a contact folder.

b. I have written a short function to "zap" my contacts folder.

c. Tweak the code from a. above to re-create the contact folder from the Access db after zap has run. You should map your access fields to the relevant field in the outlook folder.
SEE MS Article Q185361 for a list of internal fields used by ol98

Where EXCHTEST.mdb contains your data, the two functions zapthefolder and importfromaccess, and a macro called EXPORT to call the functions then quit Access.

0

merciaAuthor Commented: 2000-03-13

Do you mean that I create a function in Access that clearfs a folder in Outlook? Do you have an example of the code required as my code writing skills are not as good as yours? If you do it would be appreciated as you seem to have cracked the problem I have. Thanks

0

smithgtsCommented: 2000-03-13

This is a sample. I'm not a coder, more a support bod. But this works. Note that it is set to zap a personal folder, but it could just as well be an Exchange Folder. Also comment out the msgbox part. It was only there for debug purposes. If you don'y it will stop the auto run. Hope it helps. It clears, but doesn't delete the folder
========================================
Function ZapTheFolder()
' Set up Outlook Objects.
Dim olns As Object ' Outlook Namespace.
Dim cf As Object ' Personal Folders.
Dim newcf As Object ' Branch Folder
Dim c As Object ' Contact item.
Dim Prop As Object ' User property.
Dim itms 'Items in folder
Dim ol As New Outlook.Application
Set olns = ol.GetNamespace("MAPI") 'Name Space