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. In all other aspects the database works just fine,

regards HowardB

Howard,

I'm assuming that you went to the table design and renamed
the field from GP_PCT to GPPCT.  Depending upon your version
of Access (and some switch settings I can't recall) when
you alter the table's design it does not automatically
update your queries, forms and reports.

What I think you are faced with is your queries show
"Expr1" when viewed in design view.  *Simply* change this
to the new field name shown in the table.

For your forms and reports, again in design view, change
the ControlSource for each to the new controls.

hth,
Wayne

is this an ODBC linked table?  if you open the table from the db window does
it work OK? Have the right field name?

-----Original Message-----
From: howardb@k... [mailto:howardb@k...]
Sent: Tuesday, October 22, 2002 3:24 PM
To: Access
Subject: [access] Is this database corrupted, If so can I rescue it?


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. In all other aspects the database works just fine,

regards HowardB