Outlook calendar and ms access

K

keri

Hi,

I am a very frustrated user after searching all day for a solution to
my problem.

I currently have a form in my db that creates an apointment, saves it
to outlook and saves it in a table in my db. This works excellently.
However I want to be able to update my db appointments table with any
appointments edited through outlook, or to update outlook appointments
with any edited appointments in my db appointments table.

I have discovered;

I can link to the outlook calendar table from my db but this does not
expose the start and end times of the apointments, nor am I able to
edit the apointments.

I can export from outlook or import into access the outlook calendar
appointments table (which exposes all of the required fields) however
this is not "up to date" ie, it is only correct immediately after
imort/export, and does not run in "real time" and update after edits

I have read articles about ADO/DAO (neither of which I know anything
about), however all articles are aimed at somebody with a base
knowledge that I do not have. I have read MS articles, slapstick pages
and many many others, alongside posts on these pages, however I still
have not found a hint at a solution that I can understand.

I really am prepared to work on this, however without being able to
find a starting point I am facing a brick wall. Any help would be
appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top