title: MS Access: How to find greatest length of all fields?
body: <p>I am working to move an Access database into SQL Server. For this, I need to know how long to make the VARCHAR fields.</p>
  <p>Is there a query I can use within Access to return the longest length of a value for each column?</p>
  <p>I have found several options using the more advanced T-SQL of SQL Server, but cannot find any way to do this with Access. Since the database has almost 200 columns, I'd prefer to not have to do this with 200 manual queries.</p>