4 ms·
I once worked with a piece of 3rd party financial software, that I won't name. We used their reporting functionality to extract data to import to our firms sys
by hermitdev 7y ago
I once worked with a piece of 3rd party financial software, that I won't name.
We used their reporting functionality to extract data to import to our firms systems. Access was their intermediary data store. SQL Server -> Access -> CSV.
I had to support this, so I was one of only 2 people at the firm that was allowed to have Access installed.
Not necessarily Access's fault, but these reports failed routinely. Ended up with a Python script wrapping the whole process and retrying so I didn't get called at night. probably not Access's fault, but still leaves a bad taste in my mouth. Access is regarded as a toy, even more so than MySQL.