View Single Post
  #3  
Old September 24th, 2009, 11:32 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Editing fields in a linked table

On Thu, 24 Sep 2009 14:58:18 -0700, Fly Boy 5
wrote:

I have 3 tables linked together. Customer, Fillers & Service. All three are
one to many.

I'm trying to change the name of two or three fields in the Service table,
but it causes a pop up when I open the database. I tried to delete the field
with same results.

Any suggestions would be appreciated.

Fly Boy 5


Open your database. Select Tools... Options... General.

UNCHECK the Track Name Autocorrect Information checkbox. This feature has
richly earned the nickname "Name Autocorrupt".

Compact and repair the database, and try again.

It might be necessary to create a new, empty database; uncheck Name
Autocorrect; and import all the objects from your current database.
--

John W. Vinson [MVP]