1 Topic by Janet Simkin

  • Janet Simkin
  • Janet Simkin
  • Veteran
  • Offline
  • From: Northumberland
  • Registered: 10-05-2006
  • Posts: 260

Topic: Export to Access database

I use the report wizard to extract large volumes of records (2.2 million at the last count) and export them to an Access database for further work. This has worked perfectly for years but today the export to Access is giving me an error "Error in data export: Error loading type library/DLL". I am using R6.26 on Windows 10, and apart from this problem both Recorder and Access are fine.
Any suggestions?
Janet

Janet Simkin
British Lichen Society

Janet Simkin's Website

2 Reply by MikeWeideli

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

Re: Export to Access database

Hi

Is it working with just a few records ?

Mike Weideli

MikeWeideli's Website

3 Reply by Janet Simkin

  • Janet Simkin
  • Janet Simkin
  • Veteran
  • Offline
  • From: Northumberland
  • Registered: 10-05-2006
  • Posts: 260

Re: Export to Access database

Hi Mike,
No, I tried it with just 400 records and that gives the same error.
Janet

Janet Simkin
British Lichen Society

Janet Simkin's Website

4 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,384

Re: Export to Access database

It seems that re-registering the DLL using regsvr32 might fix the problem. However, working out which DLL that is... one for Mike probably.

Perhaps an update to Windows or Office that has caused the problem?

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

5 Reply by Janet Simkin

  • Janet Simkin
  • Janet Simkin
  • Veteran
  • Offline
  • From: Northumberland
  • Registered: 10-05-2006
  • Posts: 260

Re: Export to Access database

We are no further forward with this. If we could find out which DLL is causing the problem we could presumably reinstall or reregister it, but how can we identify the DLL causing the problem?

Janet Simkin
British Lichen Society

Janet Simkin's Website

6 Reply by MikeWeideli

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

Re: Export to Access database

I am working on it. I take it you don't get a normal R6 Error Report and that Exports to Excel etc. are OK ?

Mike Weideli

MikeWeideli's Website

7 Reply by Janet Simkin

  • Janet Simkin
  • Janet Simkin
  • Veteran
  • Offline
  • From: Northumberland
  • Registered: 10-05-2006
  • Posts: 260

Re: Export to Access database

Nothing so useful. I will attach the error message, for what it is worth.

Janet Simkin
British Lichen Society

Janet Simkin's Website

8 Reply by MikeWeideli

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

Re: Export to Access database

Hi Janet

I have asked John about this. What version of Acess are you using. Have you updated it recently ?

Mike Weideli

MikeWeideli's Website

9 Reply by Janet Simkin

  • Janet Simkin
  • Janet Simkin
  • Veteran
  • Offline
  • From: Northumberland
  • Registered: 10-05-2006
  • Posts: 260

Re: Export to Access database

I'm using Office Pro Plus 2016, version 1710. It updates monthly but this is automatic so I'm not sure how recently it last updated. Exports to excel and to text files are working fine, and I can import the text file to access if necessary.

Janet Simkin
British Lichen Society

Janet Simkin's Website

10 Reply by Janet Simkin

  • Janet Simkin
  • Janet Simkin
  • Veteran
  • Offline
  • From: Northumberland
  • Registered: 10-05-2006
  • Posts: 260

Re: Export to Access database

The latest update to Windows 10 (Feature Update 1709) seems to have fixed this problem. I have no idea how or why, but it is good to have it working again!

Janet Simkin
British Lichen Society

Janet Simkin's Website