Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Data Assist - Too Many Fields Defined

Data Assist - Too Many Fields Defined

Thread began 5/03/2011 1:10 pm by werecat321138 | Last modified 5/04/2011 10:54 am by werecat321138 | 3331 views | 3 replies

5/03/2011 1:10 pmwerecat321138

Data Assist - Too Many Fields Defined

Hi,

I am getting the following error whenever I try to update or insert a file into an existing Access Database.

I used a different form insert for people to fill out and submit and it seems to work great but when I create the Admin features using Data Assist 2.08 I get the following:

Microsoft OLE DB Provider for ODBC Drivers error '8007000e'

[Microsoft][ODBC Microsoft Access Driver] Too many fields defined.

/2008Redesign/administrator/GeneralTitleInfo_Update.asp, line 57

Line 57 is: MM_editCMD.Execute()

I do have a very complex form that uses approximately 161 fields.

Is there a way to make this work?

I am using DreamWeaver CS 5
ASP model

It is a Microsoft Access file because, while it will be used, it probably won't get more than 200 records a year.

Any help would be appreciated.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.