-2147467259 Unexpected Error from external database driver [Non admin user]

shikha77

New member
Joined
May 10, 2012
Messages
1
Reaction score
0
Points
0
I am getting this error -2147467259 Unexpected Error from external database driver when running a vba macro code at this line-.Provider = "Microsoft.ACE.OLEDB.12.0"
in below code-

Code:
MyConn = _
"Data Source=" & ThisWorkbook.FullName & ";" & _
"Extended Properties=Excel 12.0;"
Code:
[COLOR=#222222][FONT=Verdana]
Set Cn = New ADODB.Connection
    With Cn
        .Provider = "Microsoft.ACE.OLEDB.12.0"
        .Open MyConn
    End With   
[/FONT][/COLOR]

This is a simple vba macro (not using .net,sql server or ms access). Only excel is used. This works fine in following combinations- Excel 2007 & Windows Xp, Excel 2007 & Windows 7. But in Windows 7 and Excel 2010 it gives this error if the user is not admin. Interestingly, in Windows 7 and Excel 2010, if i login through admin user OR RUn excel.exe by clicking "Run as administrator" option (start-typoe excel-shift +right click-run as administrator)and then opening my excel file it does not give this error and more interestingly if after logging once through admin user and opening this excel file and closing it, I then log off and log in as normal user and open my excel file I still do not get this error.So the thing is that ONE TIME login as admin and opening this excel file temporariily fixes the issue.BUT the problem is that i need to distribute this application to various users and they will be logging it as normal users and i can not ask them to first login as admin user. Why this issue is ioccuring and what is the resolution for this? It’s very urgent , will really appreciate quick response.thanks.
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,522
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Shikka,

My apologies, but I'm not sure I can help with the tight schedule. I'm away at the moment, with very limited time to pitch in to threads. If you can hold until Monday, then I can look at this in more detail.
 

joseph4tw

New member
Joined
May 28, 2012
Messages
13
Reaction score
0
Points
0
Location
South Florida, USA
Website
www.spreadsheetsmadeeasy.com
Hello, by any chance can you attach the workbook you are using? Or maybe a dummy workbook so you don't give out sensitive data?

It sounds like you are using OLEDB to connect to the workbook itself, is that right? Do you connect to another workbook at some point?

If you're not connecting to an external data source, I would recommend using another approach.
 
Last edited:

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,522
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Oh man, sorry Shikha! I just realized that I never did get back to you on this. Joseph, thanks for reviving the thread!
 
Top