Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
chrizzle7534yYou had me at MSAccess database
How did he have a job lol.
Wabby10964yIt gets worse. How about a table ID as a MySQL formatted date time with concatenated other date at the end. A friggin ID field with spaces, colons and special friggin characters.
/me has a looooong road ahead.
Sounds like a mess by an amateur. You might want to do a new build the right way rather than fixing this especially as you will surely move off Access.
If you have an ID fields with spaces etc. who knows what you might find lurking in there. Be careful if it is moving 🐭it might bite.
philcr32214yI worked on a whole crm application for childcare company many years ago, the whole thing was written in vb6 with an access backend. 16 years ago I didn't know any better.
Thankfully times have changed.
I would hope that code is long dead and buried.
vultuk434yI recently had the pleasure of working with an access database where the developer had stored dates as seperate columns. But not only were they separated like that they were also primary keys to another table, and yes, the other table looked something like this...
ID - Month
1 - January
2 - February
3 - March
... Etc etc.