Microsoft KB Archive/199395

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

Article ID: 199395

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q199395



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 sql server 7 0

Keywords: kbhowto KB199395

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.