Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Location
    UK
    Posts
    233

    Unanswered: MS Access 2007 - What do you think?

    Don't want to go into to much details but I just wondered what the general view point and feeling were in MS Access 2007.

    I am working for a client who has an existing database built in 2007. All looks completely different and very easy for beginners to create application without to much knowledge. Great - The database I am working has 10 tables no of which have any indexes and saturated in macros gallore.

    Still nobody likes change as all my clients tell me.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Your question, I'm afraid, is not really very clear, but the best explanation/comment I've read to date on v2007, and I'm not sure who posted it, was that the learning curve for 2007 is much, much steeper for an experienced Access developer than it is for an Access novice!

    "Upgrades" are generally expected to eventually replace previous versions of any application. I remember taking a Visual Basic class, taught by the owner of an established VB development company, on the eve of
    VB. Net's release. He apologized to us on the first day of class, saying that VB6 would no longer be in use in two years time! We've seen the fallacy of that, and I expect, like VB6, Access 2003 will be around for many, many years.
    Last edited by Missinglinq; 05-18-08 at 22:58.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Well I certainly have mixed feelings about it.

    Overall, my assessment would be that the small gains are not worth the major changes.

    The amount of re-training that needs to be done for those familiar with Access 2000 - 2003 is too much to warrant the "up"grade. The "up"grade itself has a few gains and some significant losses...

    Gains/Benefits: Insignificant.
    Losses: Significant.
    Re-Training Level: Significant.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    StarTrekker had a post that listed the pluses/minuses for 2007 (I think it was about a month ago wasn't it StarTrekker?) It was a great post and you should take a look if you're considering Access 2007 (the post is in the MSAccess forums - again, about a month back - can't remember where but do a search on 2007. I think StarTrekker has the most experience using it and from what he posted, I'd have to say that if it's not a necessity (why break what's working.) I'm a fan of the 2003/XP version myself but since I've worked with all versions since Access 1.0, I'm going to upgrade eventually.
    Last edited by pkstormy; 05-17-08 at 01:59.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yeah, I am a fan of 2003 tbh, but I have to use Access 2007 for my business of creating custom database applications for other businesses...

    Anyways, the post you're referring to is here:

    http://www.dbforums.com/showpost.php...1&postcount=11

    It's kinda negative as it is a response to a question "why don't I like Access 2007?". I'll probably write a more balanced review on it at some time.... but there are very few positives to mention.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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