Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Access 2000 vs. Access 2002 using SQL2000

    Dear friends,

    i'm trying to convert one of our Access 2000 projects (ADP) into an Access 2002 project so that i can compile it into an ADE. However, i've noticed that SP's that the user is not granted sufficient rights (for example EXECUTE rights on the SQL2000 server) are not showing up in the Access 2002 "Queries" pane. They all show up in the Access 2000 "Stored Procedures" pane regardless of the rights granted to the user. Is there an explanation / solution for this so that i do not have to go around changing SQL server rights?

    Thank you for your time and any comments you may have.
    Markus
    Last edited by MarkusParkus; 09-30-03 at 17:42.

  2. #2
    Join Date
    Sep 2003
    Location
    UK
    Posts
    122
    I take it there is a reason why loading it in Access 2002 and saveing as 2002 format is not an option?
    Matt the Hat says: "what!?"
    A child of five could understand this! Fetch me a child of five!
    SCARY HARD CHALLENGE: http://www.dbforums.com/showthread.php?threadid=988682

Posting Permissions

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