"The table could not be found"

[dansonneborn]

I get an error "The table could not be found" when running a report in CE10. The data source is an ACT database on another server. When I change the logon parameters for the pageserver and jobserver it stops all my other reports from running. Anyone seen this error?

 

[pelajhia]

You probably need a log on which has both: access rights to the ACT! db AND is administrator on the box you are running CE on.
It sounds like you have one id which is admin and 1 id which has access to the other server/ACT!

 

[dansonneborn]

Pelajhia, thanks for the response! My ACT! db user, the crystal pageserver, and the domain user all log on as 'administrator'... So I guess I'm still stuck. Thanks for the suggestion.

 

[pelajhia]

I was thinking in terms of this being like an mdb file (it is a dbf file, right?)
I think the login you set in your crystal servers needs to have read access to the files in whatever directory the .dbf resides in.
I had to set up some access reports, they required that the crystal server login be able to 'map a drive' so to speak, to the folder where the access file is located (in addition to being admin of the ce server).
Anyway, perhaps I am off on the wrong tangent, but that's where I was coming from.
Good luck!