Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
detlion1643
Yak Posting Veteran
67 Posts |
 Posted - 2010-04-26 : 14:23:20
|
This is about sharing my excel workbooks that connect to sql express, but the sql express is on my local machine with windows authentication. If someone that has allowed macros and full control over the folders with the excel files are in, the vba stops trying to connect to the sql to run the queries.I am wondering if I have to share the database with full control for the people that need to access the excel files, or change the connection string because of sql being on my local machine, and they are opening the excel files over the network share.Everything worked perfect before the queries were added, so the files didn't corrupt or anything.if needed, here is the connection string:conn.Open "Provider=sqloledb;" & _ "Data Source=MAPPRICING2\SQLEXPRESS;" & _ "Initial Catalog=Pricing;" & _ "Integrated Security=SSPI" |
|
|
|
|
|
sql and sharing