Microsoft KB Archive/824261

= Jet 4.0 OLE DB Provider requires a Jet 4.0 system database =

Article ID: 824261

Article Last Modified on 6/21/2004

-

APPLIES TO


 * Microsoft Office Access 2003

-



Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies only to a Microsoft Access database (.mdb).



For a Microsoft Access 2002 version of this article, see 286376.



For a Microsoft Access 2000 version of this article, see 243466.



SYMPTOMS
When you try to use a Microsoft Jet 3.0 and later Workgroup Information file (system database) with Microsoft Jet 4.0 OLE DB Provider, you may receive the following error message:

Run-time error '3251':

Object or provider is not capable of performing requested operation.



CAUSE
The OLE DB application programming interfaces (APIs) make calls that are not supported in the Jet 3.0 and later installable indexed sequential access method (IISAM).



RESOLUTION
You must use the Workgroup Administrator utility in Access 2003 to create a new Workgroup Information file. You must re-create all user accounts and all group accounts. You must use the exact account names and the exact personal identification numbers (PIDs) that were used to create the user accounts and the group accounts in the earlier version of Access.

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

278329 How to run the Workgroup Administrator program



STATUS
This behavior is by design.



MORE INFORMATION
Steps to Reproduce the Problem  Create the c:\Test folder on a computer with Access 2003 installed. Copy the System.mdw file and the Northwind sample database file from the computer that has Access 97 installed to the Test folder that you created in step 1.

By default, the Access 97 System.mdw file is stored in the Windows\System folder (or for Microsoft Windows NT, in the Winnt\System32 folder). Start Access 2003. Create a new database.</li> Create a new module in the database.</li> On the Tools menu, click References, and then select the following references: <ul> Microsoft ActiveX Data Objects 2.1 (or later) Library</li> Microsoft ADO Ext. 2.5 (or later) for DDL and Security</li></ul> </li>  Type the following function in the new module: Option Compare Database

Option Explicit

Function fncTest

Dim conn As ADODB.Connection

Dim cat As ADOX.Catalog

Dim grp As ADOX.Group

Set conn = New ADODB.Connection

conn.Provider = &quot;Microsoft.Jet.OLEDB.4.0&quot;

conn.Properties(&quot;Jet OLEDB:System database&quot;) = &quot;C:\Test\System.mdw&quot; conn.ConnectionString = &quot;Data Source=C:\Test\Northwind.mdb;&quot; & _ &quot;User Id=Admin;Password=&quot;

conn.Open

Set cat = New ADOX.Catalog

cat.ActiveConnection = conn

Set grp = New ADOX.Group

For Each grp In cat.Groups   '<== error occurs here

Debug.Print grp.Name

Next grp

End Function </li>  Press CTRL+G, and then type the following line:

?fncTest </li> Press ENTER.

You receive the error message that is in the &quot;Symptoms&quot; section.

</li></ol>

Additional query words: Acc2003

<div class="references_section">