A 2013 naming table fields

[Dick7Access]

Sometimes I think that I am just too stupid to program Access. :banghead: All of a sudden my table field’s names either won’t stay with caps or won’t stay with those that I replace caps with lower case. I change them close the table, save it and when I open the table again it is right back the same way. Can anybody out there keep me from a slow death?

 

[nanscombe]

It may, or may not, work but ... What I would try is this.

Change the name of the field to something else, stick an 'a' on the end, and save the table.
Immediately go back in and change the name to what you want, minus the 'a', and re-save the table.

Saving the field with a slightly different name may force Access to behave rather than ignoring your changes.

 

[Dick7Access]

Thanks, that did it. I copied the field name I had and pasted it into the description area, change the name to Kooka, closed the table, open the table, made my cap's changes in the description area, copies and paste into the field name area and it stayed. That has to be a Access error and not a Dick error. If it is on my end somebody please advise me, if it is on Access end somebody please call Bill Gates and tell him.

 

[nanscombe]

Perhaps Access is trying to be too intelligent by ignoring capitalisation changes whilst the name actually stays the same?

 

[Dick7Access]

Perhaps Access is trying to be too intelligent by ignoring capitalisation changes whilst the name actually stays the same?

Who knows, but I want B.G. to know I pout when I don't get my way.

 

[Dick7Access]

I found a scarier issue along the same lines. I too use Camel Case on my column names. In the bug I found, I was linking to some spreadsheets and appending data into my tables. When I linked to a sheet that had the same column names but with different case, Access helped me out by actually changing the column names of the table to match those in the spreadsheet when it ran the append query. So if my table's column name was CamelCase but the column name in the spreadsheet was camelcase, the table's column name would be changed. It also changed some to all caps. So my name was Log and in the sheet it was LOG and my table ended up as LOG. I really thought I was loosing my mind and it is such a little thing it is very hard to find.

Hi Pat,
I suppose those things can happen when you have millions of lines of code. Anybody know the actual count of how many lines in a basic Access app?

 

[Dick7Access]

I'm not even sure what language Access is written in.

Anybody know?

 

[Dick7Access]

Anybody know?

http://wiki.answers.com/Q/What_programming_language_was_Ms_Access_written_in

[FONT=&quot]What programming language was Ms Access written in?[/FONT]
[FONT=&quot]In: Computer Programming [Edit categories] [/FONT]

• [FONT=&quot]Access Programmerwww.accessexperts.net/No job too small, use us as needed. Queries, Reports, Tables, Code help[/FONT]
• [FONT=&quot]MS Access Programmerswww.msofficeexperts.com/Reports, Conversion, Applications Competency and Customer Service[/FONT]
• [FONT=&quot]Access Programmerwww.dice.com/ApplySearch the Top Tech & Software Jobs Register at Dice.com.[/FONT]

[FONT=&quot]Ads[/FONT]
[FONT=&quot]View Slide Show[/FONT]
[FONT=&quot]Answer:[/FONT]
[FONT=&quot]Microsoft Access was developed on C#.
Source: MSDN (Microsoft Developer Network)[/FONT]

 

[SteveH2508]

A complete SWAG here- could this be Name Autocorrect or somesuch spawn of the devil kicking in?