Trouble to open XLS file with oledb

Question

When I try to open an xls file, I get this error :

Rhe Microsoft Office Access database engine cannot open or write to the file ''. 
It is already opened exclusively by another user, or you need permission to view and write its data.

I do several access but I close and dispose the connection all the time. It's on my DEV PC. On the server I get this error : Don't have read/write access on the file. This file is on \networkdisk\directory1\Files

I'll use "ACE.OLEDB" because Jet is not running on x64 server.

Any idea ?

Thanks,

Yes, you need to set "write" permission for this file on development server. — KV Prajapati, Oct 05 '11 at 08:14
Of course yes. Set "write" permission for IIS user (Users group). — KV Prajapati, Oct 05 '11 at 08:36

score 1 · Answer 1 · answered Feb 20 '13 at 16:13

1

In my case it was a file stream that had not been closed.

answered Feb 20 '13 at 16:13

Ally

4,894
8
37
45

score 0 · Answer 2 · answered Mar 23 '17 at 10:54

0

in our case, a client uploaded an excel file that is password protected

answered Mar 23 '17 at 10:54

user1465073

315
8
22

Trouble to open XLS file with oledb

2 Answers2

Linked

Related