Share via

Changing field type problems?

Tom Kosel 21 Reputation points
2021-04-12T19:10:16.333+00:00

Can anyone see potential problems with changing a field type from short text to long text? I have a inherited db that has a field designated as short text. At design time, discussion decided that there would never be a need for more than 255 chars. I guess the saying never say never is true. Now they need more characters.

See any harm in changing the type?

Community Center | Not monitored

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,786 Reputation points
    2021-04-13T16:25:00.74+00:00

    SQL Server does not have a data type called "short text" or "long text". This is apparently a MS Access question. It would be better asked on the MS Access forum.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.