Editing fields in a linked table
End users did not modify anything.
Thanks,
"Fly Boy 5" wrote:
I have converted from 2003 to 2007. Would it be easier to delete the fields
and make new ones or just make new and leave the old ones alone?
Thanks for you help
"Klatuu" wrote:
If you are trying to modify the structure of a linked table (changing a field
name qualifies), you cannot do it easily from the front end database. You
have to make the change in the database file (mdb, accdb) the table is in.
It can be done, but it takes a bit of code and is not advisable unless you
have a good reason. For example, I worked on an application where there were
about 500 different backend mdbs. The front end would use the one specified
by the user selecting a client. This was because they were all very large
with some well over a gig.
As you can imagine, if you make a structure change in this case, it is a lot
of manual work to open, modify, and save 500 mdbs. To solve this, I wrote a
small app that would use a "template" mdb where the changes had been made,
then programmatically open each mdb and make the changes.
--
Dave Hargis, Microsoft Access MVP
"Fly Boy 5" wrote:
It was all ready unchecked.
Thanks,
"John W. Vinson" wrote:
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]
|