I've been working on a project for awhile. I started out with a database that used no naming conventions at all. Queries were named with table names as long a sentences, full of special characters and spaces everywhere. The same went with table names and field names. I've posted about this elsewhere. Over months I've brought these names into compliance with a provided, if somewhat dated, Access specifications document. These pretty much aligned with what I had been using all along, i.e., prefixes like tbl for tables, qry for queries, frm for Forms, no spaces etc. So nearing the end of the project, it was decided to use SQL Server as a back end, mean I.T. got involved. After holding their nose about an Access database, the announce all tables, queries, field names must meet their quite different specifications, potentially changing the name of every object in the database.
I just looked at them and smiled. It's no skin off my teeth, but you can imagine the work involved. It's a paycheck to me IF their willing to sign it, but I can't help but shake my head over the whole matter. I try only to laugh when I leave the building.