Browse by Tags

All Tags » Access » SQL Server (RSS)
Saturday, May 10, 2008 10:56 PM

Bug in ADO, SQL Server and latest OS SPs

On a computer that is running Windows Vista, Windows Server 2008, or Windows XP, an incorrect value is returned when an application queries the identity column value of a newly inserted row in various versions of SQL Server 2005 and of SQL Server 2000...
Posted by Tony | with no comments
Filed under: , ,
Sunday, January 20, 2008 4:54 PM

SQL Server 2005 Best Practices Analyzer (January 2008)

"The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues...
Posted by Tony | with no comments
Filed under: ,
Friday, December 14, 2007 11:58 AM

SQL Server White Papers: Migration from ... Microsoft Access to Microsoft SQL Server

SQL Server White Papers: Migration from Oracle Sybase, or Microsoft Access to Microsoft SQL Server
Posted by Tony | with no comments
Filed under: ,
Wednesday, November 07, 2007 4:13 PM

Access 2003 SP3 bug on bit data type field in a linked SQL Server table

We've been seeing reports of this in the newsgroups. Here's Microsoft's KB article: After you install Office 2003 SP3, you encounter various problems in an Access project when you work with a Bit data type column in a linked SQL Server table
Posted by Tony | with no comments
Filed under: , ,
Thursday, October 18, 2007 10:14 PM

Optimizing Microsoft Office Access Applications Linked to SQL Server

Tom van Stiphout, fellow Access newsgroup denizen, alerted me to the following MSDN article: Optimizing Microsoft Office Access Applications Linked to SQL Server . A link was also added to the Access Performance FAQ . Note the following paragraph: "Developers...
Posted by Tony | with no comments
Filed under: ,
Tuesday, June 19, 2007 12:56 PM

Norton Antivirus strikes again - ODBC to SQL Server 2005

From a recent newgroup posting > I'm trying to link an Access 2003 project to a SQL 2005 database on a > network server. Everything seems to go okay until I select ODBC as the type > of source I want to link to and them nothing happens. If...
Posted by Tony | 4 comment(s)
Filed under: ,
Saturday, May 26, 2007 11:42 AM

New version of SQL Server Migration Assistant for Access available for download

SQL Server Migration Assistant for Access 1.2 - Microsoft SQL Server Migration Assistant (SSMA) 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...
Posted by Tony | 2 comment(s)
Filed under: ,