Sychronizing with Access

N

Nyla K

Is there a way to synchronize Access with Outlook calendar with multiple
users? We have a Call Center that schedules appointments with various
employees in the organization. The problem we run into is when the customer
calls to cancel an appointment but doesn't remember who they were scheduled
to meet with. I'd like to use Access to do a search by account # or name to
determine who has that appointment. Is this even possible to do?

thanks for any feedback you can give.
NK
 
D

David C. Holley

Actually, that's pretty much (on a conceptual level) as to what I'm
about to build. I'll be using an Access-based DB for reservations and
then use VBA to create & maintain the Outlook Appointments from there.
FUN, FUN, FUN.

David H
 
S

Sue Mosher [MVP-Outlook]

You might want to take a look at TabTag which will do most of the heavy
lifting for you.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
D

David C. Holley

Actually, I already have a VBA sub that loops through the appointment
items in a calendar and writes them to an Access-db, so basically it
should just take a few mods.

David H
The code by the way was from a product a few years back that was
scrapped before it went into production.
 
S

Sue Mosher [MVP-Outlook]

That's not synchronizing, is it? It's one-way copying -- much easier.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
D

David C. Holley

Actually, TabTag might be nice, but the Access-DB is too far developed
to try and migrate away from it. A SQL Server migration might be a
possibility, but not anytime soon.
 
D

David C. Holley

Actually, I'd call it synchropy. I wrote two VBA Subs. The first creates
the outlook appointment and is fired on the AfterInsert event to create
the appointment when the Access record is created. The second fires on
the AfterUpdate event, goes out to Outlook, grabs it using the entryId
and then updates all of the Outlook fields (start, end, location,
subject, body) so essentially the Outlook appointment always reflects
the key information in the Access DB. At first, I was going to go with a
create/delete method, since I thought that I would have problems
determining which fields were updated. I then realized that it didn't
matter which fields were updated, all I had to do was overwrite all the
values in the Outlook appointment.

David H
 
S

Sue Mosher [MVP-Outlook]

But what happens when the user changes the values in the appointment in
Outlook? There's nothing to prevent them from doing that.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Top