Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Real-time Diary Application (2000)

    We have the following scenario:

    Two offices connect via VPN to each other, which share a lotus smartsuite database. We currently have a manual appointment diary for showing people around houses on the half hour intervel. What we want to be able to do is to re-create the diary system in access (as the smartsuite is due to be transfered across later in the year). However we need it to be instant, so if someone takes an appointment slot, then it can not be available to anyone else. Monday - Friday at present there is one person and we make appointments for this isngle person. However shortly there will be two people monday - saturday.

    Anyone have any suggestions?
    Best Regards,

    Luke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Real-time Diary Application (2000)

    I'd use Outlook/Exchange instead of Access. In Access, you'd have to start from scratch, while Outlook has extensive calendar (diary) facilities built-in.

  3. #3
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Real-time Diary Application (2000)

    Hans,

    I am not too familiar with Exchange to be honest. We use a separate mailserver program called Mailtraq, however the diary function is not ideal, as it uses a client program to synchornise the calendar and the smallest update period is 5 minutes, which is too long and we risk double booking, etc.

    I will have to investigate further, any pointers?
    Best Regards,

    Luke

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Real-time Diary Application (2000)

    About Exchange? Look on the Microsoft website, for example Microsoft Exchange Server: Home.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •