Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 824261 - Last Review: June 21, 2004 - Revision: 2.2
Jet 4.0 OLE DB Provider requires a Jet 4.0 system database
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=286376/
)
.
For a Microsoft Access 2000 version of this article,
see
243466Â
(http://kbalertz.com/Feedback.aspx?kbNumber=243466/
)
.
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.
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).
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=278329/
)
How to run the Workgroup Administrator program
This
behavior is by design.
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.
- Create a new module in the database.
- On the Tools menu, click
References, and then select the following references:
- Microsoft ActiveX Data Objects 2.1 (or later)
Library
- Microsoft ADO Ext. 2.5 (or later) for DDL and
Security
- 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 = "Microsoft.Jet.OLEDB.4.0"
conn.Properties("Jet OLEDB:System database") = "C:\Test\System.mdw"
conn.ConnectionString = "Data Source=C:\Test\Northwind.mdb;" & _
"User Id=Admin;Password="
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
- Press CTRL+G, and then type the following line:
- Press ENTER.
You receive the error message that is
in the "Symptoms" section.
For more information about the Workgroup
Information file, click
Microsoft Office Access Help on the
Help menu, type
workgroup in the
Search for box in the Assistance pane, and then click
Start searching to view the topic.
APPLIES TO
- Microsoft Office Access 2003
| kbnofix kberrmsg kbprb KB824261 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate