Started getting Run-time error -2147024156 at the point excel vba does access createObject

amesty

New Member
Joined
Jan 25, 2014
Messages
2
Hi All,
I have an excel 2007 spreadsheet and from VBA code I call access(2007) to load a CSV into access. Running on Dell Laptop/Vista Premium SP2. This application has been running fine without any issues, i.e, I have been able to run the application several times to load the files into access. I have made some changes to other code in access and that should not be impacting this. Since last evening I am encountering [Run-time error -2147024156 (800702e4) Automation error: The requested operation requires elevation].

The only recent change to my laptop was Firefox update that I removed and still no avail.After online search for the issues I have already done this 1. Check the references 2. Made the user ID administrator 3. Disabled UAC on vista. 4. Repaierd the Access 2007 installation 5. Ran Office Diagnostics. None of this made the error message go away.

Code is called by clicked a button in excel and that button has the following procedure assigned.

Code:
Sub LoadDataIntoAcc() 'No changes to this code since it as used successfully the last time
Dim acObj As Object
Set acObj = CreateObject("Access.Application") 'Error occuring here 
.... ..................
Any help is appreciated!Thanks
 

amesty

New Member
Joined
Jan 25, 2014
Messages
2
Update: It's working now!
The one change that I had done recently was to install SQLSERVER 2005 and for some reasons, the only way I could have ODBC linked between SQLSERVER and Access is run the latter as administrator. Excel supposedly needed to be run as adminstrator and after I did this, it started working again.

Thanks all who may have read original question!
 
Last edited:

Forum statistics

Threads
1,081,989
Messages
5,362,581
Members
400,683
Latest member
LogChief

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top