Linking Excel to SQL Database + Excel 2003

N

Neil Holden

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!!!
 
J

Joel

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.
 
N

Neil Holden

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

Cheers anyway.
 

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

SQL in Excel 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to recover SQL server database from corrupt mdf file? 3
Downloading Excel file from SQL application 6
Excel to Database 7
Errors connection to SQL Server Express 2
Excel 2003, Microsoft Query - reference to subquery alias 1
TransferSpreadsheet method question 2

Top