Microsoft Access error code: ACCWeb107013

Posted on 2012-09-20
Last Modified: 2012-09-25
While trying to publish a Microsoft Access 2007 database to SharePoint 2010, I received the following error code: ACCWeb107013

Error text:    Property value is not compatible with the Web.

What it means:    The indicated Number field has its Format property set to something besides General Number, Percent or Standard. Only these formats are supported on the Web.

What to do:    Change the field's Format to General Number, Percent or Standard.

The fields giving this error are all date/time fields.  What should I do to be able to use dates ?   I can of course change to text, but then you lose the date functionality?

Any ideas ?
Question by:Scalesoft
    LVL 9

    Expert Comment

    You should be able to use dates. Here is a tutorial on publishing Access 2007 to SharePoint 2010; the data he used included dates.

    Make sure that Office and Windows are fully updated (patches). Do a compact and repair on the access database and try to publish again.
    LVL 44

    Accepted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now