Error importing excel data into access 2007
Posted on 2012-09-07
I have an access database that none of the code has changed in and has been working fine for over a year now all of a sudden when I click the import data button that reads info from an excel sheet into the database it is generating errors. the first one is as follows:
there is a box that pops up and the title is Action Failed and
Macro Name: Rearrange_Data
Action name: OpenQuery
Arguments: qryAppendPlantInformationTemp, Datasheet, Edit
Error Number: 2950
And it has 3 options Step; Stop All Macros; Continue and the only option that is not greyed out is Stop all macros. so I click that one then another smaller box pops up that says:
"There was an Error #3197 because the Microsoft Office Access database engine stopped the process because you and another user are attempting to change the same data at the same time.
Then sometimes the 2nd error is something about the property was not found. I cannot figure out why all of a sudden it quit working.. and help would be great.