Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2004

    Unanswered: ODBC & Access security

    I have an issue where a database (Access 2000 under XP) we are using has the Access security system implemented.

    We want to be able to access the data in one particular table via an Excel pivot table but when you try to build the pivot table it won't let you access the data as it informs me that I don't have the necessary permissions, although I am the administrator of the db with full permissions/rights.

    I've tried the same thing through another database that doesn't have security implemented and there is no problem.

    Does anyone know how to get over this?

    I have attached a screen dump of the error message

    Attached Files Attached Files

Posting Permissions

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