|
| |
|
|
lu lu
Posts: 418
From: wpg, mb
Status: offline
 |
access acting full - 12/9/2004 3:18:49
i created an access db with 8 tables and roughly 200 columns in each, i was entering data into a record and when i got to the 139th column i got a message of "record to big" and when i tried to save it , i was prompted that i had no choice but to lose my recently added data. each column is set up the same, as text with 50 allowed character and with all other default settings like that. the value i was putting in each was my email address 15 characters in total. Is there a setting in access that limits the amount of data for a record? what's going on...
Lll
|
|
|
|
ou812
Posts: 1611
Joined: 1/5/2002
From: San Diego
Status: offline
|
RE: access acting full - 12/9/2004 11:22:51
Wow, those are some huge table setups. Any chance you can change those around to something more managable? I'm guessing you hit some limit (It looks like the row limit is 2k, but you passed that by far) but I'm not sure which one. Here are some limits I found in the help file:
Microsoft Access database general specifications
Attribute Maximum
Microsoft Access database (.mdb) file size 2 gigabytes. However, because your database can include linked tables in other files, its total size is limited only by available storage capacity.
Number of objects in a database 32,768
Modules (including forms and reports with the HasModule property set to True) 1,000
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255
---
also Table specifications:
Microsoft Access database table specifications
Attribute Maximum
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. The actual number may be less because of tables open internally by Microsoft Access.
Table size 1 gigabyte
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 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 255
_____________________________
-brian
EnterpriseDB: Enterprise-class relational database management system
PostgreSQL: The world's most advanced open source database
| |
|
|
|
lu lu
Posts: 418
From: wpg, mb
Status: offline
|
RE: access acting full - 12/10/2004 0:10:06
the access size is only 408k
its not as big table in size and contains only test material, if you want i can post it, and you can try to add some data in a column, has anyone ran into this b4,
thanks
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
