The query did not run, or the database table could not be opened

[junior6202]

Not code related.

I have this Excel spreadsheet to display live SQL data. It was working fine and then suddenly a few users cant refresh data it gives the following message "The query did not run, or the database table could not be opened" and other users can.

13961

The connection file is saved in a shared drive and the connection string is as follows
" Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=topsoft_reports;Data Source=ccssql1;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=Computer1;Use Encryption for Data=False;Tag with column collation when possible=False"

Any help will be appreciated.

Thank you,

Junior

[Aflatoon]

Since you're using Windows authentication, I'd guess either those users don't have access to the database/table, or the data source isn't set up properly for them.