Results 1 to 11 of 11
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Nottingham, UK, Nottinghamshire, England
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Programming Access97 from Outlook2000 (97)

    Is it possible to add entries to an Access97 table from an Outlook2000 mailitem? I have a mailitem form which users use to request actions, and I want to use the fields from each action to log the requests. At the moment, I am able to add the requests to a Word table, but it's getting large and unwieldy now, and I'd rather have an Access table as I can sort and query the table much easier! But can it be done?
    Following this, I need to present the Access table in a web page for an intranet. This is fairly easy?

    Thanks <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Programming Access97 from Outlook2000 (97)

    In theory it is possible - in practice it is a bit tedious. Access will work both as an automation server and client, so you can do lots of stuff. The real issues however is the capability of Outlook in terms of using forms and logic to determine the proper functional steps. One caution - I would definitely switch to Access 2000 if you are going to try to do automation. As to the web page, if everyone is using IE, it's a pretty easy task to display stuff on an intranet web page - easier in Access 2000 than in Access 97, and you get more functions in Access 2000. If you want to more than display a static page, i.e. you want to allow updating, that gets more challenging, but is doable.
    Wendell

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Nottingham, UK, Nottinghamshire, England
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Programming Access97 from Outlook2000 (97)

    Thanks for that Wendell. I guess my problem is that I can program Access97 to act as a server quite happily, but not as a client. Any chance of anyone just giving me the basics to get Outlook to put a field into an Access table? Thanks again.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Programming Access97 from Outlook2000 (97)

    You've got it backwards. Access 97 is not an automation server, it only acts as a client. A server is an application that will allow you to control it through automation. Access 2000 is an automation server but not 97.
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Nottingham, UK, Nottinghamshire, England
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Programming Access97 from Outlook2000 (97)

    You're right of course, Charlotte. I did know that but got it round my neck! So if Access 97 is NOT an automation server, then I can't do what I want to do, is what you're saying, yes?

    Thanks for the reply though.

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Programming Access97 from Outlook2000 (97)

    Have a look at <A target="_blank" HREF=http://www.helenfeddema.com/CodeSamples.htm>Helen Feddema's</A> code samples. Maybe you can find something to start with.
    Francois

  7. #7
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Nottingham, UK, Nottinghamshire, England
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Programming Access97 from Outlook2000 (97)

    Thanks, Francois, there's one that looks promising, although it's exporting Outlook contact data to a new Access 97 table row. Perhaps it's amendable for mailitem fields. I'll have to get it from home though as the firewall at work won't allow me ftp. Thanks again.

  8. #8
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Programming Access97 from Outlook2000 (97)

    Ahmmmm, Ahem, I hate to argue with you, but I think Getz et. al. is on my side. At least Chapter 21 of the 97 ADH is titled something like "Using Access 97 as an Automation Server" - I think that capability was introduced in 97, and I believe it carries over to 2000 and 2002. We frankly don't use it much because we are usually doing our stuff in Access - form design in Outlook, Word, and to some extent Excel is a significant pain.
    Wendell

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Programming Access97 from Outlook2000 (97)

    You may be right. I've worked with every version except 95 and they start to run together after a while. I was thinking 97 was not an automation server, but I've also run across MSKB articles saying it was. Sorry for the confusion.
    Charlotte

  10. #10
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Programming Access97 from Outlook2000 (97)

    I think one point needs to be made again - I believe you are asking from trouble if you want to try to program Access 97 as an automation server from Outlook 2000. It will make certain assumptions about the object model of Access 97 that are definitely not true, and will probably let you do things syntatically that are incorrect for Access 97. If you decide to proceed in that direction, definitely update your databases to Access 2000.
    Wendell

  11. #11
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Nottingham, UK, Nottinghamshire, England
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Programming Access97 from Outlook2000 (97)

    Point taken, Wendell, and thanks again. Unfortunately, it's out of my hands, upgrading to Access 2000 - we're only just on the point of moving to Windows 2000! But I can at least agitate for it!

Posting Permissions

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