troubleshooting Question

Publish Access Database to SharePoint - Upload Error

Avatar of SasDev
SasDevFlag for United States of America asked on
Microsoft Access
4 Comments1 Solution1021 ViewsLast Modified:
I am trying to publish my database to SharePoint, but after entering the Server URL and Site Name and clicking the "Publish to Access Services", the synchronization runs for about 40 minutes and then gives the following message:

There was an error uploading the data in the tables being created on the server. The Microsoft Access database engine encountered an error while communicating with SharePoint. More detailed information: 'Field 'CustomerName' in table 'CustomerTable' contains invalid field value '<male symbol>'. Remove this invalid value from your field and try to complete the operation again.'

(Here is a picture of the actual <male symbol> that appears:

I've tried the following to fix the issue:

Searched on '<male symbol>' in the 'CustomerName' field, but no results were found.
Visually looked at the 'CustomerName' field looking for any oddities, none were found (this field contains 25,250 records)
Moving the data into Word and Excel and performed searches to see if the '<male symbol>' would appear, but no luck.
Ran the 'Web Compatibility' in Access.  No issues with compatibility.

Can anyone please tell me how I can find this symbol ' ' ?
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros