1 Topic by nmrs

  • nmrs
  • Veteran
  • Offline
  • From: London
  • Registered: 22-11-2006
  • Posts: 387

Topic: Unexpected table 'Taxon_Occurrence_Ext_Ref' in import file. Aborted.

I'm getting the above importing a zipped NBN Access database. The table exists in my version v6.29.0.290. I did find a post from 2016 discussing permissions:

GRANT UPDATE ON Taxon_Occurrence_Ext_Ref to R2K_FullEdit
GRANT DELETE ON Taxon_Occurrence_Ext_Ref to R2K_FullEdit
GRANT INSERT ON Taxon_Occurrence_Ext_Ref to R2K_FullEdit

From what I can see these are implemented and I'm importing with an R2K_FullEdit-enabled account.

I'm at a loss as to why the table is 'unexpected' when it is clearly there.

Anyone else come across this?

Les Evans-Hill
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme

nmrs's Website

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Unexpected table 'Taxon_Occurrence_Ext_Ref' in import file. Aborted.

Hi
On the surface of it this it appears to be a fairly serious problem which I will need to investigate.   Was the export generated by a version of R6 prior to 6.28.

Mike Weideli

MikeWeideli's Website