Is this database corrupted, if so can I fix it?

[HowardB]

Hi All,

I have just come up against an instance in a database I am building where Access does not recogise a field on an underlying table when I am trying to reference it through code associated with a tabbed form called CaseDetails. The actual field that exists is called GPPCT but in the Access object browser I only see a reference to a field GP_PCT which no longer exists because I renamed it. This twisted situation means I cannot reference the GPPCT field at all. A search for GPPCT in the Cardiac.mdb (my database) object indicates this field does not exist (but it is there an in use in reality) whilst it does find references to GP_PCT (which no longer exists)and I don't appear to be able to edit this information? If anyone has come up against this type of scenario and lived to bragg about it in pubs later I would welcome your input regarding any possible explanation or solution,

regards HowardB

 

[essnrv]

Is there any space between GP and PCT ?

 

[HowardB]

Hi essnrv,

In answer to your question no there are no spaces except the ones that form gaps in my understanding

regards HowardB

 

[essnrv]

Try Like this
Me![GP PCT]

 

[HowardB]

Hi

Me![GPPCT] (no spaces) just worked and I have no idea why it didn't work before. I suspect user error but happily I will never be able to prove it. Thanks for your help, everything appears to be in order,

regards HowardB