Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MS Outlook & MSAccess (MS Office 2003`)

    I have just been told to up drop all other projects and see about starting a New application. I have to create about 16 new forms using MS Outlook and 1 new database using MS Access. I have MS Office 2003 and during the next 12 months different Dept. will be upgrading from MS 2000, 2002 to 2003. My new database uses Access 2003 but it is in 2000 format.

    If I create the forms can other Users use them?
    In my script should I create it for Office 2000 or 2002 or 2003 ?
    In my script do I use DAO.DBEngine.36 or something else?
    I have several forms already created in Outlook 97, anyway I can convert the forms and/or script for 2002/2003 Office?

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS Outlook & MSAccess (MS Office 2003`)

    It is clear that this is a different project from the one(s) you have been working on in the last few months. OTOH, in some ways, the questions - paricularly the last one, resemble some of the content of earlier threads by you, such as those starting with <post#=427025>post 427025</post#> and <post#=426851>post 426851</post#>. Turning to your questions specifically:<UL><LI>Presumably you mean Outlook Forms. How would this be different from earlier posts on this problem?<LI>It sounds as if you do not know yet how your application is going to be rolled out. That is, where your end users are likely to be in terms of Office version. Without that information, it is a difficult question to answer clearly.<LI>Are there going to be many other Access users on your site? The implementation of ADO for Access 2003 is far less problematic than it is for Access 2000.<LI>How are the upgrade questions on these Outlook forms different from the questions you have raised in earlier posts?[/list]HTH
    Gre

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: MS Outlook & MSAccess (MS Office 2003`)

    Regarding forms compatibility, I would be very concerned about backwards compatibility. Every version of Outlook contains loads of new features; the odds that you can totally avoid those seem low if you develop in Outlook 2003. Maybe you need access to Outlook 2000 at least to do the forms.

    Regarding database access, it will take some time to learn, but you should consider using ADO (ActiveX Data Objects) rather than DAO. There used to be tons of articles on the web about how to rewrite DAO code for ADO; probably they're still out there, but now you have to somehow discard all the pages about ADO.NET, which will not be relevant to your project.

  4. #4
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS Outlook & MSAccess (MS Office 2003`)

    Sorry about the message. Someone in my group jumped the gun and sent this.

    Yes, this is a continuation of our last project. Just yesterday it was mandated that it will ALL be converted and operational by Dec. 31, 2004. We (2 people) have to convert ALL our forms (16) from Outlook 97 and be online. We have MS Office 2003 loaded in our new computers but I had hoped to designed them for 2000,2002 users. The Form and Database are no problem, we just need the time to get them created. Our problem is with the scripts.

    How much of a drastic change is the sciprt in the MS Office? Where we used to add: SET DAO = APPLICATION.CREATEOBJECT("DAO.DBEngine.36")
    we are told that that is not correct and that we need to add a PROVIDER, SERVER and who knows what else.

  5. #5
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: MS Outlook & MSAccess (MS Office 2003`)

    Perhaps your HR person can counsel you on your multiple personality issue. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Is this the real Dan Reyes now?

    Anyway, "provider" strings are a concept related to ADO which, as noted above, is the more modern interface.

  6. #6
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS Outlook & MSAccess (MS Office 2003`)

    Is this the real me? Not sure if I want to be. For today i am not here, I will try not to answer phones and just work on designing new Forms and New Access Tables. That way by Monday I should be ready to start looking at the code behind this maddness.

    They coming to take me away... Ha Ha Ha ha ha.

Posting Permissions

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