Unable to change the case of some field names. 1

[AtekMan]

Hi all, for years now I've been a good boy and have been using field names such as 'TotalBalance'. However as some of my databases were written in the bad old days when I was undisciplined about naming conventions many of my older systems have capitalized field names eg... 'TOTALBALANCE'.

My problem is somewhere Access remembers these capitalized names and when in my code I try and change such names to mixed case, Access automatically changes them back to all caps!

Global Search/Replaces don't work. Neither does temporarily renaming the field to something else.

Is there anyway to force Access to accept the revised cases?

 

[Remou]

As far as I know, you will have to import everything into a new database.

http://lessthandot.com

 

[genomon]

I've never tried it, but decompiling might also work:

http://www.granite.ab.ca/access/decompile.htm

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[AtekMan]

Thanks Remou, I tried that but the results were mixed though I managed to alter some of my fields.

Genomon, wow never heard of this. I'll have to read up on this first to see exactly what's involved. Thanks.

 

[Remou]

Decompile is great, I keep a small script and decompile regularly when I am messing about:

http://wiki.lessthandot.com/index.php/Decompile

http://lessthandot.com

 

[AtekMan]

Ok, I've tried the decompile option, and it does indeed let you change the case of those stubborn fields. However once you recompile they capitalize again! :-(

 

[Remou]

It can be very difficult indeed to get rid of an annoying capitalization. In one case, I finally output all the code and forms to text and ran find-and-replace across the text files to correct the capitalization before importing to a new database. I realize this is a tad OTT or more likely, OCD.

http://lessthandot.com

 

[AtekMan]

Wow, and I thought I had got compulsive about this kind of thing! :-D I've never got quite that bad, but in total I must have spent countless hours adjusting the cases of field names on the various systems I've written.

 

[genomon]

I've been close to setting the PC on a stone altar at midnight under a full moon, while throwing salt over it and chanting.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[Remou]

That is not a problem, as long as your ritual does not involve beautiful naked virgins, it is probably ok. Sad, but ok.

http://lessthandot.com

 

[LarrySteele]

Thanks for the script link. I haven't had to decompile for quite a long time. It's nice to have the script available for a quick run just in case.