Drivers error

Results 1 to 3 of 3

Thread: Drivers error

  1. #1
    Join Date
    Dec 1969

    Default Drivers error

    Microsoft OLE DB Provider for ODBC Drivers error &#039;8007000e&#039; <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Too many fields defined<BR><BR>- What does it&#039;s mean ...

  2. #2
    Join Date
    Dec 1969

    Default Oooohhh....

    Haven&#039;t seen that one before.<BR><BR>I read something about Access not liking over 200 fields being defined in a select/update/insert. Can you print the SQL string you&#039;re sending when this error occurs?<BR><BR>Craig.

  3. #3
    Join Date
    Dec 1969

    Default RE: Drivers error

    I&#039;ve come across this type of error before.<BR><BR>The limit is 255 fields in a query for access. Even if you&#039;ve not got 255 fields in your query, if you are using an update query for some reason each field is referenced twice (don&#039;t know why) so even if you have 200 fields and update query will see that as 400 fields.<BR><BR>Not sure if theres a work around for this.<BR><BR>Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts