Sychronizing with Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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.
 
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
 
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.
 
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
 
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
 
Back
Top