I'm builing an app which creates new table fields within an Access2000 DB 

using asp. This is the code:



query_txt="ALTER TABLE "&datatable&" ADD COLUMN "&newelementname&" CHAR

(255)" 

set objconntable=Server.CreateObject("ADODB.Command")

objconntable.ActiveConnection=strconnect

objconntable.CommandText=query_txt

objconntable.CommandType=adCmdText

objconntable.Execute

set objconntable=Nothing



This code is (or seems to be) OK as it works for the first 6 or 7 fields 

created. After that it returns an error:



Microsoft OLE DB Provider for ODBC Drivers error '80004005' 



[Microsoft][ODBC Microsoft Access Driver] Record is too large. 



/contman/contman/create_element.asp, line 97 



(line 97 is the "execute" statement).



Can anyone help ?





regds



Simon Garstin 

After some research.......apparently Access records are limited to "just

under" 2k

see http://support.microsoft.com/support/kb/articles/Q111/3/04.asp.



Actually after trying this out the threshold is 2020 bytes. This "limit"

however does not seem to apply when one adds fields manually !! - only when

using OLEDB. Does this ring any bells with anyone ? Looks like I will have

to continue development using MSDE...



Simon Garstin



----- Original Message -----

From: Simon Garstin <sgarstin@t...>

To: Access ASP <access_asp@p...>

Sent: Tuesday, September 04, 2001 12:24 PM

Subject: [access_asp] 80004005 error





> I'm builing an app which creates new table fields within an Access2000 DB

> using asp. This is the code:

>

> query_txt="ALTER TABLE "&datatable&" ADD COLUMN "&newelementname&" CHAR

> (255)"

> set objconntable=Server.CreateObject("ADODB.Command")

> objconntable.ActiveConnection=strconnect

> objconntable.CommandText=query_txt

> objconntable.CommandType=adCmdText

> objconntable.Execute

> set objconntable=Nothing

>

> This code is (or seems to be) OK as it works for the first 6 or 7 fields

> created. After that it returns an error:

>

> Microsoft OLE DB Provider for ODBC Drivers error '80004005'

>

> [Microsoft][ODBC Microsoft Access Driver] Record is too large.

>

> /contman/contman/create_element.asp, line 97

>

> (line 97 is the "execute" statement).

>

> Can anyone help ?

>

>

> regds

>

> Simon Garstin

>

>




>

>

>