The workgroup information file is missing or opened exclusively by another user.' Due to planning to move into 2007, we are not using nor have ever used a workgroup identification file through access. The database password on the data source was set through the Set Databa Password which had to be done on an exclusive open.
I have a 3rd party dashboard application that I can only use SQL authenticated logins to connect to the database.
I'm trying to create a query within the application that will directly access an excel file through a linked server.
As a test, I login to SSMS as the sql auth user to run the linked server query below but the following error is returned:
select *
from Corporate...[Sheet1$]
OLE DB provider 'Microsoft.ACE.OLEDB.12.0' for linked server 'Corporate' returned message 'Cannot start your application. The workgroup information file is missing or opened exclusively by another user.'.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider 'Microsoft.ACE.OLEDB.12.0' for linked server 'Corporate' reported an error. Authentication failed.
Msg 7303, Level 16, State 1, Line 1
![Another Another](https://www.iris.co.uk/assets/IPP-3028-2-2.png)
Cannot initialize the data source object of OLE DB provider 'Microsoft.ACE.OLEDB.12.0' for linked server 'Corporate'.
When I login as a Windows auth user, I can successfully run the above query.
I noticed within the linked server's security definition that I cannot specify a windows auth user as the mapped Remote User or as the Remote login
I've tried creating a Credential object with the identity of the windows user and assign that object to the sql auth user but to no avail. I still get the same error
I am using SQL Server express so the option of an automated server agent job to import the excel file is not available.
Details:
SQL Server Express 2012
Office version: Excel 10
Provider: Microsoft.ACE.OLEDB.12.0
I have a few data sources in access that I need to connect to programatically to do things with behind the scenes and keep visibility away from users.
Said datasource has a password 'pass' as I'm going to call it here. Using this connection method I get an error attempting to use the open method
'Cannot start your application. The workgroup information file is missing or opened exclusively by another user.'
Due to planning to move into 2007, we are not using nor have ever used a workgroup identification file through access. The database password on the data source was set through the Set Databa Password which had to be done on an exclusive open.
Ive spent a good while changing around my connection options, where to put the passwords etc and either cannot find the right format, or (why I'm asking here) I think there may be some other unknown that I must setup to do this. Anyone out there got some useful information?
MohgerothMohgeroth
1 Answer
Your connection string seems to be incorrect. Try:
-- http://www.connectionstrings.com/access
FionnualaFionnuala