Microsoft Access ADP file and Office Service Pack 3 problem

Posted on 2007-10-08
Last Modified: 2013-12-05
Bit of a worry this one. I have a Microsoft Access ADP (data project) file that is used throughout the company connected to Microsoft SQL Server 2000.

Today, I upgraded to Office SP3 and I now have the following problem:

When I go to add a record on a form - it makes two of the tick boxes default to "True" (when they don't in SP2) and it won't add a record to the database, it behaves as though it has but doesn't add it.

This is a potential nightmare if my users start upgrading. Has anyone else come across this?
Question by:pauldonson
    LVL 77

    Accepted Solution

    There are several problems  being reported with SP3.

    The advice from Access Watch and other advisors is to steer clear for the time being.

    Author Comment

    OK, that gives me some reassurance that it isn't just me!

    LVL 1

    Expert Comment

    Force accepted.
    Community Support Moderator

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Suggested Solutions

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    728 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

    18 Experts available now in Live!

    Get 1:1 Help Now