Friday, September 26, 2008

Security Update for SQL Server 2000 Service Pack 4 and MS Access MSDE 2000 (KB948111)

A security issue has been identified in the SQL Server 2000 Service Pack 4 and the MSDE 2000 sql server engine used by MS Access that could allow an attacker to compromise your system and gain control over it. Download the hot fix.

Quick Details:
Version: 8.00.2273
Date Published: 9/26/2008
Download Size: 16.5 MB - 39.4 MB Download size depends on selected download components.

Wednesday, September 24, 2008

Latest SQL Server Fixes

FIX: SQL Server 2005 Service Pack 2 is not successfully updated when you try to install or to uninstall security update KB948108 or security update KB948109

FIX: No rows are returned when you use the sp_replqueuemonitor stored procedure to list the queued messages for a queue-updating subscription in SQL Server 2005

New v4.0 of SQL Server Migration Assistant 2005 for MS Access

Microsoft SQL Server Migration Assistant (SSMA) 2005 for Access is a tool for migrating databases from Microsoft Access to Microsoft SQL Server 2005. SSMA for Access converts Access database objects to SQL Server database objects, loads those objects into SQL Server, and then migrates data from Access to SQL Server. SSMA for Access supports Access 97 - Access 2007 databases.

Tuesday, September 16, 2008

Access 2003 and 2007 Hot Fixes

Hot fixes are now available for the following Microsoft Access issues:

Access 2003

  • An Access 2003 project (.adp) stops responding when in table Datasheet view, you delete all child rows from a parent row and then delete the parent row. This issue applies only to an Access 2003 project.
  • A database in .mdb format in Access 2003 SP3 stops responding when you try to delete a parent record from a table in Datasheet view and the Datasheet view uses a sub-datasheet that is expanded to show the related child records.

http://support.microsoft.com/kb/956722

Access 2007

  • In Access 2007, you create a query that does not contain a parameter. When you export the query to a Microsoft Office Excel Worksheet, the Enter Parameter Value dialog box opens.
  • When you open a chart object in Access 2007 on a computer that is running Windows Vista or Windows Server 2008, you see a blank chart.
  • After you upgrade Access 2003 to Access 2007, operations on existing forms have slow performance.
  • You cannot use the SetValue macro in the click events of a Button control to set the Locked property of a Check Box control in Access 2007.
  • You have a printer that has a staple feature. When you print an object in multiple copies in Access 2007, all the copies are stapled as one unit. However, you expect that each copy is stapled individually.

http://support.microsoft.com/kb/956054

Tuesday, September 09, 2008

Security Update for Office 2007

Microsoft today issued a security patch for a vulnerability in Office 2007 that could allow arbitrary code to run when you open a maliciously modified file.

Thursday, September 04, 2008

Free Open Source Spell-Checker for Access Run-time

You can download free PCESoft.com's MS Access Spell Checker for Access 97 -2007, including source code from their web site.

Wednesday, September 03, 2008

Configuring the Windows Firewall to Allow SQL Server Access

Configuring the Windows Firewall to Allow SQL Server Access To access an instance of SQL Server through a firewall, you must configure the firewall on the computer that is running SQL Server to allow access. This MSDN article discusses how to configure the Windows firewall, but the basic principles apply to other firewall programs.
New SQL Server 2008 Articles

New articles from Techrepublic.com on SQL Server 2008: