I've been asked to produce a patient appointments, records and billing
system for a clinic who use Office 2000 (but who would probably upgrade
to XP if I told them they needed to).

Ideally I'd like, rather than trying to reinvent the wheel, to make the
patients' bookings (and keep their contact details) in Outlook and then
keep their medical records and details of treatment sessions in Access,
where I'll also be handling the clinic's inventory and billing.

This is proving a lot more difficult than I thought it would.    I've
tried, for example, importing my own appointments book into Access only
to find that I've got details of when I physically made the appointment
but not when I made it for.

Anyone got any ideas about what Outlook's underlying table structure is,
or even where I can find all the files and queries it uses?    And if
anyone's actually tried to do something similar and could give me some
pointers that would be great.

Steve