topic Re: How to use RefreshSchemaCache (VBA) ? in ArcObjects SDK Questions

How to use RefreshSchemaCache (VBA) ?

ChristopheDAMOUR — Tue, 29 Jun 2010 11:45:39 GMT

Hi,

I am having problems with Access standalone tables structure not being updated.

I found the following advice in the old forum :
- Open your workspace.
- Cast the workspace factory to the IWorkspaceFactorySchemaCache interface.
- Call IWorkspaceFactorySchemaCache.RefreshSchemaCache, passing your workspace in as a parameter.

I tried to to that in VBA as follow, but I get a "Method or data member not found" error :

    Dim pFactWorkSpace As IWorkspaceFactory
    Set pFactWorkSpace = New OLEDBWorkspaceFactory
    Dim pWorkSpace As IWorkspace
    Set pWorkSpace = pFactWorkSpace.Open(pPropset, 0)

    'Dim pWorkspaceFactorySchemaCache As IWorkspaceFactorySchemaCache
    'Set pWorkspaceFactorySchemaCache = pFactWorkSpace
    'pWorkspaceFactorySchemaCache.RefreshSchemaCache (pWorkSpace)

Thanks for any hint.

Re: How to use RefreshSchemaCache (VBA) ?

AlexanderGray — Wed, 30 Jun 2010 13:28:09 GMT

If you look at the help for IworkspaceFactoryschemacache, it is only implemented for SDEworkspacefactory. You are using an OLEWorkspaceFactory...

The schema cache is only meant for sde schema caching.

Re: How to use RefreshSchemaCache (VBA) ?

ChristopheDAMOUR — Tue, 27 Jul 2010 11:45:59 GMT

Thank you very much for your answer, agray1.

Do you know if there is any other way to refresh database tables structure ?

--
Christophe