Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 10th, 2005, 12:38 PM
Authorized User
Join Date: Aug 2005
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default Data field limits


I recenttly came across a problem with Access 2000. Is ther only a certain number of datafields one can have in a table? I am using ASP.Net and when I try to post data to the database, it tells me that there are too many values being submitted.



Old October 15th, 2005, 02:27 PM
Friend of Wrox
Join Date: Jul 2005
Posts: 150
Thanks: 0
Thanked 0 Times in 0 Posts

If the table has arealy been created and saved, then it is not problem with the table. It sounds like a code problem. How are you posint g the data? If with an Append query, then the SQL has is not correct. The value list does not match the field list is probobly what the error is telling you.

"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual Web Developer 2005 Express Edition - Limits snew BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 7 November 15th, 2007 01:00 PM
Data not fitting into field v4seasons SQL Server 2000 2 October 13th, 2007 05:55 AM
SQL trigger, rollback , update, limits brucenx SQL Server 2000 1 December 17th, 2004 07:05 AM
Time Limits on a Script freddo PHP How-To 0 September 1st, 2004 03:17 PM
performance limits / data sets justinhume Pro PHP 1 July 15th, 2004 01:49 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.