topic Error from AccessWorkspaceFactory.Create in ArcObjects SDK Questions

Error from AccessWorkspaceFactory.Create

JohnFritzen — Wed, 30 May 2012 13:26:14 GMT

Hello,

For the following code....

 Dim pWorkspaceName As ESRI.ArcGIS.Geodatabase.IWorkspaceName
 Dim pWorkspaceFactory As ESRI.ArcGIS.Geodatabase.IWorkspaceFactory
 'Set up new database
 pWorkspaceFactory = New ESRI.ArcGIS.DataSourcesGDB.AccessWorkspaceFactory
 pWorkspaceName = pWorkspaceFactory.Create("C:\Temp", "foo.mdb", Nothing, 0)

I get the error...

System.Runtime.InteropServices.COMException was caught
  ErrorCode=-2147220973
  Message=Exception from HRESULT: 0x80040213
  Source=ESRI.ArcGIS.DataSourcesGDB
  StackTrace:
       at ESRI.ArcGIS.DataSourcesGDB.AccessWorkspaceFactoryClass.IWorkspaceFactory2_Create(String parentDirectory, String Name, IPropertySet ConnectionProperties, Int32 hWnd)

I am using vs2010 and ArcMap 10.
The code is in a windows form. The form is called from a ICommand class. My code was converted from VB6 and ESRI 9.x.

When I am debugging, this line and step into it

pWorkspaceFactory = New ESRI.ArcGIS.DataSourcesGDB.AccessWorkspaceFactory

It goes to the Deactivate subroutine of the Form code.

Thanks for your help!

Re: Error from AccessWorkspaceFactory.Create

RichWawrzonek — Fri, 10 Dec 2021 20:08:27 GMT

This problem comes up frequently in this forum.

Workspaces are singleton objects and you should use the activator class to instantiate them. See documentation:
http://help.arcgis.com/en/sdk/10.0/arcobjects_net/conceptualhelp/index.html#//00010000043p000000

In your case the line:

pWorkspaceFactory = New ESRI.ArcGIS.DataSourcesGDB.AccessWorkspaceFactory

should be replaced with:

pWorkspaceFactory = CType(Activator.CreateInstance(Type.GetTypeFromProgID("esriDataSourcesGDB.AccessWorkspaceFactory")), IWorkspaceFactory)

Re: Error from AccessWorkspaceFactory.Create

JohnFritzen — Thu, 31 May 2012 13:48:12 GMT

Hi Rich,

Thanks for your help. The documentation on singleton objects was also very helpful.

Unfortunately the problem persists.

Re: Error from AccessWorkspaceFactory.Create

RichWawrzonek — Tue, 05 Jun 2012 21:19:00 GMT

You need to make sure the specified directory (C:\Temp in your case) already exists. The IWorkspaceFactory.Create() method will not create it for you.

Re: Error from AccessWorkspaceFactory.Create

JohnFritzen — Wed, 06 Jun 2012 12:15:20 GMT

Yes, that dir exists.

Re: Error from AccessWorkspaceFactory.Create

RichWawrzonek — Wed, 06 Jun 2012 16:12:51 GMT

Is this an ArcGIS COM extension or a standalone app?

Re: Error from AccessWorkspaceFactory.Create

JohnFritzen — Thu, 07 Jun 2012 09:57:42 GMT

It is a COM extension. Runs in a windows form launched from an icommand class.

Re: Error from AccessWorkspaceFactory.Create

NeilClemmons — Fri, 10 Dec 2021 20:08:30 GMT

There are several things that could cause an issue here.

 Dim pWorkspaceName As ESRI.ArcGIS.Geodatabase.IWorkspaceName
 Dim pWorkspaceFactory As ESRI.ArcGIS.Geodatabase.IWorkspaceFactory
 'Set up new database
 pWorkspaceFactory = New ESRI.ArcGIS.DataSourcesGDB.AccessWorkspaceFactory
 pWorkspaceName = pWorkspaceFactory.Create("C:\Temp", "foo.mdb", Nothing, 0)

As already mentioned, use the Activator class to create an instance of the workspace factory. Also mentioned, the directory C:\Temp must already exist. Additionally, the database foo.mdb should not already exist. I don't think the Create method will overwrite an existing database. The final parameter to Create is a window handle. Since you're calling this method from a Windows Form, you should be passing in the handle of that form (Form.Handle.ToInt32). In cases where the code is not called from a form, use the application's handle (IApplication.hWnd). You also need to have write permissions on the Temp directory. I can't imagine why you wouldn't but if the code is still failing you might want to make sure.

Re: Error from AccessWorkspaceFactory.Create

JohnFritzen — Fri, 08 Jun 2012 10:31:48 GMT

Thanks for your help. I did try a version of the code passing a window handle. I also tried passing and empty property object instead of "Nothing".