SQL Plugin – limited and randomly crashes

1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 4.75 out of 5)
Loading...
Go back to All Questions Login or Register
381 views
0

Hello,

i actually have some troube to get things working with your plugin.
The SELECT Functionality made its job so far but UPDATE and INSERT did not work for some reason.

Example SQL-Code:
UPDATE [Rohdaten_all$]
SET [Interkontinental]= “JA”
WHERE [Quelllokation Kontinent] = [Ziellokation Kontinent]

causes the fologwing Error:
“An error has occured. Be aware that DELETE operations are not permitted when using ACE.OLEDB”
Besides even without the WHERE-Condition i getting this error everytime.

Furthermore the result seems to be randomly:
– sometimes error-message appears directly and makro stops
– sometimes for any reason it calculate for a short time, error-message appears and only a few records are updated
– sometimes it calculates really slow. when i stop the macro after 10 minutes for example 100 records are found

I hope you can help me with that issue!!! That would be awesome.

0

Hi Thomas,

thanks for the feedback.

Unfortuntately the UPDATEs and INSERTs indeed vary in their reliability. This is not due to the AddIn but due to the underlying MS Query functionality. Try closing and saving your workbook and reopening.

Regarding other errors, please provide more details:
– sometimes error-message appears directly and makro stops
Which macro?
– sometimes for any reason it calculate for a short time, error-message appears and only a few records are updated
In what situations? In case you refresh the query? MS Queries do not refresh by themselves unless explicitly you set a background refresh
– sometimes it calculates really slow. when i stop the macro after 10 minutes for example 100 records are found
This would depend on your query, amount of data etc. Unless you can explain the scenario

Simply the best place to learn VBA!

Error: Please enter a valid email address

Error: Invalid email

Error: Please enter your first name

Error: Please enter your last name

Error: Please enter a username

Error: Please enter a password

Error: Please confirm your password

Error: Password and password confirmation do not match