Missing Table?

[ccastillo]

Last week we connected to our Symposium 4.2 Sybase database via Crystal Reports 8.5. When connected to the data source there was a table named: blue.dbo.agent. However when we connected yesterday the blue.dbo.agent table is no longer there. This is the same on all three machines I've tested the connection on. Does anyone know what causes this and how to resolve it?

Thanks In Advance,

 

[IdoMillet]

Is it possible someone changed the permissions on that table or that you logged in as a different user?

hth,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[ccastillo]

It is possible but I don't know where to check the field permissions. I've also tried several different logins and all get the same result.

Any help would be greatly appreciated.


Thank you for the quick response.

 

[ccastillo]

It turned out the access class within Symposium had been changed to exclude blue.dbo.agent. I found this out when I created a new access class and migrated myself and the other users to it. Once migrated over we were able to see blue.dbo.agent again.

Thanks to everyone for your assistance.