Text field size

[golfinray]

I have a split database with the BE on a LAN, FE on each user's machine. A
user requested more space in a comments textbox of a form. I open the BE and
the length of that field was set to 50 in the table. I changed it to 150
characters. I went back to my FE and relinked. That field is still set to 50.
What gives? Thanks!!!

 

[Jeff Boyce]

Milton

Access noted the definitions of that table when you first linked it.

Since then you've modified the definition.

Re-link the table.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Douglas J. Steele]

No offense, but are you sure you made the change in the database to which
you linked? (It's not that uncommon to have multiple copies of back-ends for
test purposes)

 

[golfinray]

I'm sorry, guys, but I swear I relinked it over and over and it would not
catch it. I finally just deleted that link and re-linked it (file\get
external data\link) and it worked. Sometimes I think I'm losing my mind! I
should have tried that first. BTW, Doug, I checked that too. I can never be
too careful. Thanks so much!!!
--
Milton Purdy
ACCESS
State of Arkansas

No offense, but are you sure you made the change in the database to which
you linked? (It's not that uncommon to have multiple copies of back-ends for
test purposes)

 

[John W. Vinson]

I finally just deleted that link and re-linked it (file\get
external data\link) and it worked.

That's the only reliable way. I even will compact the database after deleting
the link and before creating the new one.