Problems using Access as datasource for pivot table

[jondmontgomery]

I am trying to use an Access database as a source for a pivot table. I am able to locate the database through the PTable Wizard and connect, but when I get to the point of choosing my data fields it won't let me drill down.

It will show me all the tables and queries, but will not let me drill down into the individual fields.

I am able to perform this function with nearly identical databases with no issues.

Does anyone have any experience dealing with this problem?