MS Access Error: Record is too large

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.

All Forums

Other Forums

MS Access

MS Access Error: Record is too large

Author

Topic

sqlslick
Yak Posting Veteran

83 Posts

Posted - 2009-07-21 : 16:43:47

Hey guys,

I am trying to create a new table with 29 fields using the following command:

CREATE TABLE ITEM_MASTER
(
FIELD1 CHAR,
FIELD2 CHAR,
FIELD3 LONG,
FIELD4 DOUBLE,
FIELD5 CHAR,
...
FIELD29 CHAR
)
;

When I run the SQL statement I receive the following error:
"Record is too large"

I did some research and if I'm understanding this correctly the CREATE TABLE statement in MS Access has a limit of ~2,000 bytes. I did some experimenting and the table structure cannot exceed 2,026 bytes.

If this is the case then why does MS Access let you copy the structure of an existing table that well exceeds the 2,026 bytes using the SELECT INTO statement below:

SELECT *
INTO ITEM_MASTER
FROM ITEMS
WHERE 1 = 2
;

Is there any way around this "Record is too large" error without having to specify field lengths that do not exceed 2,026 bytes at table creation? I don't really want to do what I have below:

CREATE TABLE ITEM_MASTER
(
FIELD1 CHAR(50),
FIELD2 CHAR(50),
FIELD3 LONG,
FIELD4 DOUBLE,
FIELD5 CHAR(50),
...
FIELD29 CHAR(50)
)
;

Thanks in advanced for your help!!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources