Accessing attached tables in Enterprise reports

[cybermje]

Hi,

I'm new to this forum and hope there's someone out there who can answer my question. I am using Enterprise 8 std edition and am running reports from a MS Access database. I have attached tables in my database and am getting a "Error detected by database DLL. [On Page Server: BASECAMP.pageserver]" because of these attached tables. I don't get the error when I import the tables (rather than attaching them) in Access. How do I access these attached tables without getting this error message?

Thanks,
Mark

 

[AEldridge]

Is there security applied in the DBMS from which the tables are attached? It seems like the page server does not have permission to access the attached tables.

Try removing this security and/or running the page server service under a named user account rather than the local system account.

Hope that helps. Alan Eldridge
Melbourne, Australia