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

    Access and Vista (any)

    Has anyone had any experience using Access (any version) with Vista? I do some work for a software house that got the following e-mail from one of its clients:

    <hr>I just got through reading an article in a developers forum on how Windows Vista will no longer support access because vista will be using SQL due to security issues due to access. If this is the case are there any plans to come up with a SQL version/front end for MTS? Hiring a SQL administrator is Not in any budgets......It is being said that service pack 1 for vista when it comes out, access will not be compatible with vista which will not support odbc drivers or jet which is needed for access.<hr>
    Now, I know this is just some stupid rumor, or at best some misinterpretation of some minor situation. However, on the off-chance there might be some minor compatibility issues that we need to be aware of (probably unrelated to this rumor), I just wanted to know what experiences anyone here might have had.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Access and Vista (any)

    I haven't used either Windows Vista or Office 2007, but...

    Microsoft has released Access 2007 at roughly the same time as Windows Vista. It is the most significant update in years, confirming Microsoft's commitment to Access. As far as I know, there *have been* plans of abandoning Access earlier on, around the turn of the century, but more recently Microsoft has returned to the Jet Engine and DAO as the platform of preference for smaller databases. I don't believe they'll dump Access in Vista SP1.

  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: Access and Vista (any)

    Hans,

    I knew that to be the case also. I didn't believe that Access was being dumped, but as is often the case, these rumors start from some little seed and get blown out of proportion. And I just didn't want to dismiss this without finding out if ANYONE knew ANYTHING that might have gotten miscontrued. I figure if the people here haven't seen it, it ain't there!
    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: Access and Vista (any)

    There has been a shift in emphasis in Access, and that has started or resurrected a lot of rumors. Access is being positioned as a front end to SQL Server or as a standalone desktop app for power users. The user security is being removed in 2007, so for multiuser applications SQL Server Express or full SS will be necessary if you need to restrict user authorizations. They're giving away the developer tools free, but the loss of user security means you either roll your own security or rely on SQL Server. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

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

    Re: Access and Vista (any)

    Oh, and it has nothing to do with Vista particularly. The same thing applies if you install Access 2007 on Windows XP.
    Charlotte

  6. #6
    5 Star Lounger st3333ve's Avatar
    Join Date
    May 2003
    Location
    Los Angeles, California, USA
    Posts
    705
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Access and Vista (any)

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17> There's some kind of sparkly little bug crawling around in your hair!

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

    Re: Access and Vista (any)

    It's the light reflecting off her crown... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

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

    Re: Access and Vista (any)

    Naw it's just my sparkling personality! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    Charlotte

  9. #9
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Chicago, Illinois, USA
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access and Vista (any)

    Are you referring to Access user-level security? Many of my apps rely on it, help.

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

    Re: Access and Vista (any)

    Access 2007 still supports user-level security in databases in Access 2000 and Access 2002/2003 format (i.e. .mdb and .mde databases), and the security tools such as the User-level Security Wizard are still available.
    However, the new native Access 2007 file format (.accdb) doesn't have user-level security. If you convert an existing database to Access 2007 format, all user-level security will be removed.

    See Set or change Access 2003 user-level security in Access 2007

  11. #11
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Chicago, Illinois, USA
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access and Vista (any)

    Thanks for the clarification!

  12. #12
    5 Star Lounger st3333ve's Avatar
    Join Date
    May 2003
    Location
    Los Angeles, California, USA
    Posts
    705
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Access and Vista (any)

    <img src=/S/igiveup.gif border=0 alt=igiveup width=31 height=23>There I go again -- mistaking a feature for a bug.

Posting Permissions

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