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

    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.
    Last edited by MarkusParkus; 09-30-03 at 16:42.

  2. #2
    Join Date
    Sep 2003
    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!

Posting Permissions

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