Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / September 2004

Tip: Looking for answers? Try searching our database.

exceed the limit of rows for a table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Veronica - 14 Sep 2004 17:37 GMT
Hi,

I want to enter fields more than 255 rows in a table.
How can I do?  Thanks for your help.
Lynn Trapp - 14 Sep 2004 17:52 GMT
Do you mean rows or columns? There is no limit to the number of rows you can
enter, but you can only have 255 columns and there ain't no way to get
around that -- as my daddy used to say, "It's ungetaroundable."

Now, let's talk about why you might need 255 columns, if that's what you are
referring to. Basically, YOU DON'T. If you need that many columns there is
something wrong with the design of your database.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> Hi,
>
> I want to enter fields more than 255 rows in a table.
> How can I do?  Thanks for your help.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.