Computer Learning Zone CLZ Access Excel Word Windows

To declare that Earth must be the only planet in the universe with life would be inexcusably big-headed of us.

-Neil deGrasse Tyson
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Courses > Access > Seminars > SharePoint > Lessons
Back to SharePoint Seminar Lessons    Comments List
Max Number of Characters Upload Images   Link   Email  
Carmen Vazquez 
I shared my tables to Sharepoint Lists but now I'm getting an error and I think it's from the table - "The maximum number of characters allowed is 255"

Do I have to clear this setting from all the tables before moving them?
Richard Rost 
What kinds of fields are these? Long text?
Carmen Vazquez 
These are all short text and long text.  I'm getting the issue as soon as I click on the form - even in the date field
Richard Rost 
Interesting. Never seen that behavior before. First run down the Troubleshooter. If that doesn't work, post a few screen shots so I can see what's happening.
Carmen Vazquez 
I will do that and get back to you.
Carmen Vazquez 
I did the following:
1) removed the SharePoint link
2) Compact & Repair (backup too)
3) went through and tested my forms with no issues
4) re-link to SharePoint list
5) delete existing tables
6) re-name sharepoint links since they had a (1) at the end
7) clicked on a field on my form and the pop-up message was:
      The Maximum number of characters allowed is 255

I think I've narrowed it down to a specific table because even though I get the error message it still accepts the date I've chosen, any text entered and drop downs picked until I get to the drop down for this table.  I literally wouldn't let me move out of the field nor save, just kept yelling at me about the maximum number of characters. I had to exit the form to get out of it.  

There is nothing that sets that table apart from the others.  The previous combo box has an OnChange event to requery the Scope Categories combo box.

Carmen Vazquez 

Richard Rost 
That's weird. I've never encountered that before. Try removing options from that list until you find the one causing it? Start with the longest ones? This is one of those things that's very hard to troubleshoot without being able to play with your database.
Jon Capps 
Permissions 10:56 there is a quick blurb about publish entire database to sharepoint, did this get covered in a later topic or class?
Carmen Vazquez 
I managed to fix the issue, I reverted back to local tables.  

There is an option on my Access > Database Tools > under Move Data there's a SharePoint option.

I used that and it got rid of the issue.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in SharePoint Seminar Lessons.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/28/2024 6:44:30 AM. PLT: 0s