ACC2000: Determining If You Are Running MSDE or SQL Server 7.0

ID: Q199395

The information in this article applies to:
  • Microsoft Access 2000
Moderate: Requires basic macro, coding, and interoperability skills.


SUMMARY

To see whether you are running Microsoft Data Engine (MSDE) or Microsoft SQL Server 7.0, you can check the Sqlstp.log file located in your Windows or Winnt folder.


MORE INFORMATION

The setup log file, Sqlstp.log, is created during setup and contains detailed information about your Microsoft Data Engine or Microsoft SQL Server 7.0 configuration. To open this file, follow these steps:

  1. Start Notepad.


  2. On the File menu, click Open.


  3. In the Open dialog box, browse to your Windows or Winnt folder.


  4. In the Files of type box, select All Files (*.*.)


  5. In the File name box, type Sqlstp.log.


  6. Click Open.


If the Sqlstp.log file is very large, you may need to open it in WordPad or another text editor.

In the first several lines, the entry "SQL Server ProductType:" tells you what version you are running. The Microsoft Data Engine will say "Office," whereas Microsoft SQL Server 7.0 will say "Standard" for this entry.

Example Entries for Microsoft Data Engine

16:20:05 Begin Setup
16:20:05 7.00.549
16:20:05 Mode=Normal
16:20:06 System: Windows 98
16:20:06 Mapping: 0x1
16:20:06 SQL Server ProductType: Office
16:20:07 Begin Action: CheckRequirements

Example Entries for Microsoft SQL Server 7.0

09:35:26 Begin Setup
09:35:26 7.00.517
09:35:26 Mode=Normal
09:35:27 Begin Action: CheckRequirements
09:35:27 System: Windows NT Server
09:35:27 Version: 4.0.1381
09:35:29 SQL Server ProductType: Standard

Additional query words: inf acc2000

Keywords : kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbhowto


Last Reviewed: May 13, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.