Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KnooKie
Aged Yak Warrior
623 Posts |
 Posted - 2002-11-14 : 07:44:30
|
| I know within Access97 that you can only link in SQL Server tables with 256 fields or less (it'll chop off from 257 up if more exist) due to the limitations of Access97.Does this also apply within SQL2000 and XP ?? or can they handle SQL Server tables with more fields (i am aware of rowsize limitations) ? I assume the latter does anyone know ?===========Paul |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-11-14 : 07:58:27
|
| Hi Paul. I just tested with SQL2000 and Access XP. It can only handle 255 fields. Actually, it is a limitation of Access itself. One access table can only have 255 fields, regardless of how it's created. |
 |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-11-14 : 08:02:04
|
| Look at this for the complete set of limits for a table in Access XP (from the Access help file):Number of characters in a table name 64 Number of characters in a field name 64 Number of fields in a table 255 Number of open tables 2048; Table size 2 gigabyte minus the space needed for the system objects Number of characters in a Text field 255 Number of characters in a Memo field 65,535 when entering data through the user interface; 1 gigabyte of character storage when entering data programmatically Size of an OLE Object field 1 gigabyte Number of indexes in a table 32 Number of fields in an index 10 Number of characters in a validation message 255 Number of characters in a validation rule 2,048 Number of characters in a table or field description 255 Number of characters in a record (excluding Memo and OLE Object fields) 2,000 Number of characters in a field property setting |
|
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-11-14 : 08:29:58
|
| Thankyou===========Paul |
|
|
|
|
|
|
Linking SQL tables in Access