FIX: RepUtil:CompactJetRepository Doesn't Work with DSN Name

ID: Q169307

The information in this article applies to:

Microsoft Visual Studio 97
Microsoft Visual Basic Learning, Professional, and Enterprise Editions for Windows, version 5.0

SYMPTOMS

RepUtil:CompactJetRepository doesn't work with DSN Names.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. This has been fixed with Visual Studio Service Pack 1.

For additional information about the Visual Studio 97 Service Pack 1, please see the following article in the Microsoft Knowledge Base:

Q170365 INFO: Visual Studio 97 Service Packs - What, Where, and Why

MORE INFORMATION

Steps to Reproduce

Set up a DSN that points to a Jet repository.

Pass the DSN name into CompactJetRepository function.

Expected:

The code should recognize that the DSN points to a valid Jet database.

Results:

The Repository returns a "Failed to compact the database" error.

Additional query words:

Keywords : kbVBp500 kbVS97sp1fix kbVS97sp2fix kbvbp500sp1fix kbvbp500sp2fix
Version : 5.0 97
Platform : NT WINDOWS
Issue type : kbbug