I am doing a lot of „data shuffling“ right now. Don’t ask, it includes a BI, various data sources and people that didn’t understand requirements on one side and people that didn’t communicate them properly on the other side. So far, typical BI implementation.
In order to get the job done, I created a Microsoft Access 2007 database (please keep your rant for you – it’s a tool for mass data manipulation AND it is available on my laptop). Some time during the process, values had to be manipulated manually (done in Excel) and then the stored state in the database had to be adjusted to reflect those manipulations.
So I created a delete and an update query to ensure that the latest data is imported. And then… well, great. Microsoft Access 2007 does not allow your very own database file to delete data from a table within the same database file – WTF!? It tells you it’s in „disabled mode“, although last time I checked, I wasn’t disabled, and the database didn’t look that way either.
Solution: either sign your database (get a certificate, get this, do that, …) or: „Office Button“, „Access Options“, „Trust Center“, „Trust Center Settings“, „Trusted Locations“ and add every location your databases might reside on your disk in to that dialogue. Which makes the „Trust Center“ pretty useless, because that’s practically disabling the disabling of „untrusted“ databases, but on the other hand – if you can’t work otherwise, you’ll probably couldn’t care less.
If you want to solve this issue in another way than bombing what Microsoft means is „security“, there’s a blog post explaining how to do the necessary steps. I didn’t have the patience, I had an actual problem…
