Need help interpreting error message

P

Phil Sharpe

Does anyone know what the following error message means:

"Microsoft Excel
Client Safety Options do not allow pass through statements to be issued to
the data source."

It happens when I try to refresh the data in a report spreadsheet that my
boss created (he's on holiday).
I'm using Excel 2002 SP3, data is coming from an SQL Server 2000 SP3
database, and I'm using a network admin account.

TIA,
Phil
 
J

Jamie Collins

Phil Sharpe said:
Does anyone know what the following error message means:

"Microsoft Excel
Client Safety Options do not allow pass through statements to be issued to
the data source."

It happens when I try to refresh the data in a report spreadsheet that my
boss created (he's on holiday).
I'm using Excel 2002 SP3, data is coming from an SQL Server 2000 SP3
database, and I'm using a network admin account.
Click to expand...

Sounds like you haven't got the required SQL Server permissions. Are
you using sql on the client (Excel) side e.g. SELECT * FROM MyTable?
Is there an intermidate Jet database? You may only have permissions to
run stored procedures e.g. EXECUTE MyBossStoredProc.

Jamie.

--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Excel Error: Too many client tasks 1
Client Safety Options 1
Problem with Excel Help 5
Error Editing an MS Query in Excel 1
Microsoft][ODBC SQL Server Driver]Syntax error or access violation 0
"Client Safety Options do not allow pass through statements to th. 1
"Too many fields defined" error message 1
Refreshing Pivot Table on a protected spreadsheet tab 1

Top