Linking Excel to SQL Database + Excel 2003
 

I have produced queries to link with live SQL Database and this works fine
with me - I'm an administrator.

When I standard user opens the excel document they are getting the error
message:

Connection Failed:
SQL State '08004'
SQL Server Error: 4060
Server Rejected the connection; Access to selected database has been denied.

Like I say it allows me to open fine so i'm guessing its a permission issue?
But where? Please Help!!!

Linking Excel to SQL Database + Excel 2003
 

Debug the problem by having the user directly open the MDB file. There culd
be many reasons for the database error. It could be the entire MDB file or
just smme of the tables.

"Neil Holden" wrote:

I have produced queries to link with live SQL Database and this works fine
with me - I'm an administrator.

When I standard user opens the excel document they are getting the error
message:

Connection Failed:
SQL State '08004'
SQL Server Error: 4060
Server Rejected the connection; Access to selected database has been denied.

Like I say it allows me to open fine so i'm guessing its a permission issue?
But where? Please Help!!!

Linking Excel to SQL Database + Excel 2003
 

Hi thanks for the response, I am connecting it to SQL no Access.

Cheers anyway.

"Joel" wrote:

Debug the problem by having the user directly open the MDB file. There culd
be many reasons for the database error. It could be the entire MDB file or
just smme of the tables.

"Neil Holden" wrote:

I have produced queries to link with live SQL Database and this works fine
with me - I'm an administrator.

When I standard user opens the excel document they are getting the error
message:

Connection Failed:
SQL State '08004'
SQL Server Error: 4060
Server Rejected the connection; Access to selected database has been denied.

Like I say it allows me to open fine so i'm guessing its a permission issue?
But where? Please Help!!!