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