How do I change the width of a column?

  • Thread starter Thread starter Terry Watson
  • Start date Start date
T

Terry Watson

I am using Access 2007. I have a database with over 30,000 records. Is there
any way to change the width of a column where that it will accept more than
62 characters? I can change the width of the field, but not the number of
characters accepted. Any help would be appreciated. Thanks.
 
I am using Access 2007. I have a database with over 30,000 records. Is there
any way to change the width of a column where that it will accept more than
62 characters? I can change the width of the field, but not the number of
characters accepted. Any help would be appreciated. Thanks.
Click to expand...

Open the table in design view. Select this field; look at the "Field Size"
property of the field in the lower left of the screen.

62 is a peculiar size but I suppose it could have been set that way when the
table was created! The field can be any size from 1 to 255 characters. If you
need more, change the fieldtype from Text to Memo.

John W. Vinson [MVP]
 
Access MDB does not support 30,000 records

you need to move to SQL Server to increase the column size
 
I speak the truth

I've had serious problems with 25mb of data and a half dozen users

on the other hand; I've also babysat a dozen tables with more than a
million records.

It is a travesty when anyone, anywhere-- uses MDB for anything

you can't always forecast the growth of your databases / applications

if your applications were as successful as mine; you would NEED to use
Access Data Projects
as it is; your databases aren't popular enough because they're slow as
**** and using obsolete database engine
 
Todos said:
I speak the truth

I've had serious problems with 25mb of data and a half dozen users
Click to expand...

Ok which is it?

Funny there are a lot of people here who have had larger Access
databases used in commercial multi-user environments and not had problems.
mmm ... I wonder what the problem is?
 
I don't give a crap about what 'has worked under optimal conditions'

I am here to say that I am sick and tired of a piece of shit database
engine-- I love MS Access-- but MDB-- I'd rather be homeless

Access Data Projects rock

you won't have to rebuild your app when you hit 25mb of data
you won't have to rebuild your app when you hit 50mb of data
you won't have to rebuild your app when you hit 100mb of data
you won't have to rebuild your app when you hit 1gb of data
 
Back
Top