MDE to MDB Conversion Service
ACCDE to ACCDB Conversion Service

IN THE SPOTLIGHT: MDE to MDB Conversion Service

(also supports: ACCDE to ACCDB, ADE to ADP, etc)

TELL ME MORE

Full restoration service (including source code) for MDE, ACCDE and ADE files

Access Database Repair Service

IN THE SPOTLIGHT: Access Database Repair Service

An in-depth repair service for corrupt Microsoft Access files

TELL ME MORE

Professional, friendly service for repairing corrupt Microsoft Access files (MDBs, ACCDBs, etc)

vbWatchdog

IN THE SPOTLIGHT: vbWatchdog

VBA error handling just got easier...

" vbWatchdog is off the chart. It solves a long standing problem of how to consolidate error handling into one global location and avoid repetitious code within applications. "

- Joe Anderson,
Microsoft Access MVP

Meet Shady, the vbWatchdog mascot watching over your VBA code →
(courtesy of Crystal Long, Microsoft Access MVP)

TELL ME MORE

vbWatchdog: A unique code library offering global error catching for your VBA & VB6 projects.

vbMAPI

IN THE SPOTLIGHT: vbMAPI

An Outlook / MAPI code library for VBA, .NET and C# projects

Get emails out to your customers reliably, and without hassle, every single time.

Use vbMAPI alongside Microsoft Outlook to add professional emailing capabilities to your projects.

TELL ME MORE

vbMAPI: An easy-to-use Outlook / MAPI code library for VBA, .NET and C# projects.

Code Protector

IN THE SPOTLIGHT: Code Protector

Standard compilation to MDE/ACCDE format is flawed and reversible.

TELL ME MORE

Protect your valuable intellectual property, by securing your MDE/ACCDE projects using Code Protector

twinBASIC

Looking to take your VBA skills further?...

Discover twinBASIC — a powerful new development platform that expands on VBA and VB6 with advanced features, modern tools, and enhanced compatibility. Perfect for those ready to elevate their projects or transition from VBA, twinBASIC lets you build on what you already know and take your applications to the next level!

Try out twinBASIC Community Edition - it's free!

Bugs introduced in Access 2003 SP3

1 votes:

2,993 views No comments

by Allen Browne, 31 January 2008 (for Access 2003)

Flaws in Microsoft Access

Provided by Allen Browne, December 2007. Updated October 2008.

Bugs introduced by SP3 for Office 2003

As every developer knows, fixing one bug may introduce another.

Unfortunately, Service Pack 3 introduced a range of new Access bugs:

Combo boxes go blank if their RowSource is a table field that has something in its Format property.
Access 2003 crashes if a combo's RowSource is a table with more than 31 fields. Demo.
Visual Source Safe has serious problems with A2003 SP3.
Bit field in SQL Server table fails.
SHAPE in SQL Server view fails.
Append query dialog (Query dialog) fails to show the first table in your database.

The Office 2003 SP3 bugs also affect Word, Excel, Powerpoint, Outlook and Document Imaging.

Also, you will find numerous file types are blocked after you install SP3. The link explains how to re-enable them.

Microsoft has released a hotfix for some of these Access bugs.

October 2008 update: Some users say the hotfix also solves a problem where Access 2003 will not run at all, forever saying,
"Please wait while Windows configures Microsoft Office Professional Edition 2003."

Home

Index of tips

Top

Rate this article: Your rating: Poor Your rating: Not so good Your rating: Average Your rating: Good Your rating: Excellent

Give me more tutorials!

This is a cached tutorial, reproduced with permission.

Have your say - comment on this article.

What did you think of 'Bugs introduced in Access 2003 SP3'?

No comments yet.

Why not be the first to comment on this article?!

Have your say...

iTech Masters | VAT: GB202994606 | Terms | Sitemap | Newsletter

Name
E-mail	(e-mail address will be kept private)
Comments

	Comments require approval before being displayed on this page (allow 24 hours).