Accessing via Internet, query blows up

[TidewaterJoe]

Recently upgraded from 6.5 to 7.0. Afterward, when we access application on our external web server remotely via internet, one query blows up, offering the following: Q: Field Whendiscoverdate not found.

All others work.

If I access the app from with our network, everything is fine. Any ideas would be greatly appreciated.

Joe

 

[JFoushee]

Are you using a generic userid behind the internet version (ie anyone walking off the street could use it), or are you loging in with your username/password?

If it's a generic user, it may not have permissions to look at that field, similar to someone trying to access HR-specific information in the Employees table.

Was that field added later, or at the time of table creation?