Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Upgrading (Acc97sr2)

    I am working on a multi-user front-end / back-end setup using Acc97, and we have decided to upgrade to Acc2000. Someone suggested to my boss that we do our front-end programming in VB instead of using access and VBA. What are the benefits / downsides if any to making this switch? The front-end consists of some very complex forms with multiple subforms (a few layered 3 deep) and many behind the screens procedures being called - some manually, some automatically. I also have a number of SQL statements built/executed on some of the screens, along with some pre-compiled queries called from the screens or executed manually. Many queries contain VBA functions - iif, switch, etc, and some user defined functions as well. There are also lots of reports, many with considerable coding/function calls in them.
    Anyone have experience with this?
    Thanx for any help!

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

    Re: Upgrading (Acc97sr2)

    Here is my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>. Perhaps others have a different perspective.

    Since you already have the whole thing set up in Access, I would strongly suggest staying with Access, or a mixture of Access for the frontend and SQL Server for the backend. Upgrading to Access 2000 will take some work - you'll run into problems undoubtedly. But converting the application to VB will be much more work.

    It *is* possible to do everything you want in VB, but some things that are easy in Access require a lot of effort in VB. Reporting in particular (with Crystal Reports for instance) is more difficult.

    Regards,
    Hans

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Upgrading (Acc97sr2)

    I wholeheartedly agree with Hans. Upgrading to Access2000 should be a relatively simple process. Reprogramming in VB will be long and expensive. And for what benefit? Unless there is some compelling reason, why put yourself through that?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Upgrading (Acc97sr2)

    Is it even *possible* to nest subforms in VB? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    Charlotte

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

    Re: Upgrading (Acc97sr2)

    Got me there. Probably not. Never tried... <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

Posting Permissions

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