Article ID: 272326 - View products that this article applies to.
This article was previously published under Q272326
If you have Microsoft Visual Studio 6.0 Service Pack 4 (SP4) installed, when you use Visual Data Tools with an Access 97 or 2000 database, you may receive the following warning:
This version of the database design tools is not compatible with SQL Server 2000 database, so you cannot save changes from this tool to the SQL Server 2000 database. To modify a SQL Server 2000 database, use the SQL Server 2000 Enterprise Manager.
Click OK to dismiss the dialog box, and you can continue to edit the database objects.
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article. This bug was corrected in Visual Studio 6.0 Service Pack 5.
For additional information about Visual Studio service packs, click the following article numbers to view the articles in the Microsoft Knowledge Base:
194022To download the latest Visual Studio service pack, visit the following Microsoft Web site:
(http://support.microsoft.com/kb/194022/EN-US/ )INFO: Visual Studio 6.0 Service Packs, What, Where, Why
(http://support.microsoft.com/kb/194295/EN-US/ )HOWTO: Tell That a Visual Studio Service Pack Is Installed
Steps to Reproduce Behavior