Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jan 2001
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Outlook as relational dbase - possible?

    I have been asked a set of forms to collect information from a group of users. From the way the users' needs have been described to me, this is really a job for Access. However, not in a million years will I get this group using an Access dbase for this.

    What I'd like to know is if anyone has had any luck building custom forms in Outlook 2000 to create an Access-like experience. In particular, I would like users to use one form to feed information into another form.

    (For instance, a user fills in 10 different fields in one form and when he saves it, those 10 pieces of data populate other forms' fields.)

    If anyone has ever seen/attempted this kind of thing, I would just appreciate a confirmation that this can/can't be done.

    Thanks.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook as relational dbase - possible?

    the closest i've seen were forms popualting an SQL database and the other forms were populated from the database.

    outlook does not sound like the right tool for the job, although if they are using exchange server (2000 would be better) and/or office xp (with team services) pounding it into the square hole might be a lot easier. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    Lounger
    Join Date
    Jan 2001
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook as relational dbase - possible?

    Thanks for the comments.

    I agree that this is totally the wrong way to do this, but they want it in Outlook and that's that (small company, involved management, executive-level inertia).

    I'll figure something out. Thanks again.

  4. #4
    5 Star Lounger
    Join Date
    May 2001
    Location
    Washington, USA
    Posts
    750
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook as relational dbase - possible?

    We've had to do this a few times. Similar situation in that our staff live in Outlook and want to access everything else from there. In our experience the real determinant is reporting requirements. You can create fields and store data in folders, but getting it back out as reports is really tough. We had to store duplicate information in SQL server and use Access to report on it. Works, but a real kludge.

  5. #5
    Lounger
    Join Date
    Jan 2001
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook as relational dbase - possible?

    One thought I had - and will try out - is to build it in Access and use data access pages to collect the data - we can set the home page of a public folder to the data access page. That way they can see it in Outlook (biggest issue), but we can use database-like functionality.

Posting Permissions

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