This is not for the faint of heart!
Although tracking calendars seems a simple task, it quickly becomes a data
nightmare, as people want more and more functionality.
Best advice, decide how simple you can make your application, then work for
a week to make it simpler!
Now to the question.
1. Can I export outlook calendar to Access (Yes). From outlook
(file/export/export to file/access) . Problem is that each export creates a
database so you would then have to do a second import to get into your
application. See data structure below.
Your task then would require adding a field to identify the calendar source
from one of your 25 client/victum/subjects.
Some way to seperate out the Required and Optional Attendees, resources,
etc. then cross reference them.
Example.
Jon has a meeting with Joy in his calendar Jon -->meets --> Joy
One may want to add/verify that Joy has also scheduled this meeting and it
appears in Joy's calendar
now need to check for a Joy --> Meets--> Jon. (otherwise No Joy!)
(couldn't reist)
Anyway this is getting a bit long, and I think you get the picture. Work,
work, work to define the 'problem space' and what the program must do before
actually starting to do anything.
Best of luck.
Ed Warren
-----------------------------------------------------Outlook to Access data
structure
Columns
Name
Type Size
Subject
Text 255
StartDate
Text 255
StartTime
Text 255
EndDate
Text 255
EndTime
Text 255
Alldayevent
Yes/No 1
Reminderonoff
Yes/No 1
ReminderDate
Text 255
ReminderTime
Text 255
MeetingOrganizer
Text 255
RequiredAttendees
Text 255
OptionalAttendees
Text 255
MeetingResources
Text 255
BillingInformation
Text 255
Categories
Text 255
Description
Memo -
Location
Text 255
Mileage
Text 255
Priority
Text 255
Private
Yes/No 1
Sensitivity
Text 255
Showtimeas
Integer 2
