I didn’t want to rant. But, yeah what’s going on in Redmond
I didn’t want to rant. But, yeah what’s going on in Redmond
The first bug that blows my mind is, when editing your data source it takes that last character of your SQL statement sometimes. Even after you just told it that you didn’t want to save your changes.
The second one is when field names are qualified with the table names on order by clause the SQL statement errors when the form runs. Considering that the editor is always trying to edit them to be this way this it really becomes annoying. I have seen new users to access send hours trying to figure out what happened
The third one is that the diagrams you make in the enterprise manager crash access. The ones created in Access 2003 don’t work in the enterprise manager. I haven’t ever looked for a fix or explanation, beyond service packing my SQL client. That didn’t fix anything.
Fourth access projects can get corrupted when they are interrupted during startup. Despite my best attempts I have never repaired one successfully. If I didn’t use a source control system my project would have been corrupted and rendered useless several times. You could say don’t kill your task and this won’t happen. However, you only get one chance to learn this lesson. Sometimes I still kill the thing and take a chance because I am crazy too.
I have been in the UNIX world and the Windows world; and, I must say that the Windows world seems to be terribly more productive. However, the lack of bug fixes and improvement to Access is disheartening to me. Office 2003, it is going to be 2006 soon and I have heard nothing of a new version. I guess I should be a good programmer and use .net or something. The problem is I can get allot more done with Access.