Change the order of the Manage Import tasks window

[chiefweigum]

Here is a list of my References

[chiefweigum]

Here is a list of in References box

[isladogs]

Hi
You haven't added the required Microsoft Office 12.0 Object Library reference:



I would also strongly recommend you replace the old DAO 3.6 reference with the newer Microsoft Office 12.0 Access Database Engine Object library also shown above

Does that fix your error 31602?

[chiefweigum]

I thought because it was checked off that it was already added. How do I add it? Clicking OK doesn't do anything.

[isladogs]

I thought because it was checked off that it was already added. How do I add it? Clicking OK doesn't do anything.

Tick the checkbox to add a reference then click OK to close the dialog box

[chiefweigum]

If I click on the checkbox, I get the error below. Since it is already checked and I click OK and then run the Task, I still get the 31062 error.

[isladogs]

Sorry but you've lost me. The reference I mentioned, Microsoft Office 12.0 Object Library, was not checked in your screenshot
Have you added it since?
Error 31602 appears to be specific to A2007 and does not exist in later versions
It may be that there is an issue preventing the code working in that version but I can't replicate it at the moment
Remember it was designed for A2010 or later

If testing an import file, try clicking modify external file path, specify the correct path for the file then click Execute Action.
Then click Run Task & Execute.
That allowed the task to run for me in A2007 though I then got error 2164 - you can't disable a control while it has the focus.
That's a version specific error to A2007 that is easily fixable if it works otherwise

[chiefweigum]

It was checked when I sent the screen shot (2nd line down from my 3:43 post today - see above) and when I enter the path or even try to rename the Task, I get the 31602 error. It sounds like my A2007 version will not work with these new fixes. That's too bad as it would safe me lots of time each morning. I really appreciate you taking the time to help me. If, in the meantime, you know how to fix the 31602 error, that would be great.

Thanks a bunch

[Micron]

It's late on the UK side of the pond so I'll chime in in case this is timely.
2nd line down in the image of your list is not what you were told to set? That is Microsoft Access not Microsoft Office.

[isladogs]

I don't know what post you sent at 03:43 as the times are displayed relative to the time zone for each person viewing the thread.
You probably mean the screenshot in post #17.

As @Micron said, you are confusing references. The one required is highlighted in the screenshot I gave in post #18.
I tested the app without that reference and got error #31602 in A2007. When I restored the reference, that error disappeared.

As mentioned in post #22, I then get error 2164 but that is easily fixed.
Version specific references such as this are inevitable as the app wasn't written for A2007

[chiefweigum]

My apologies, I was looking at the wrong one. I do not have the Microsoft Office 12.0 Object Library listed in my options so how do I get it added to the list?

[chiefweigum]

It doesn't show up when I click Browse unless it has a different name otherthan Microsoft Office 12.0 object Library

[Welshgasman]

Here are miine in 2007
Print Time: 12:11:51 :: Item - Name and Description
Item 1 VBA Visual Basic For Applications 4 0
Item 2 Access Microsoft Access 12.0 Object Library 9 0
Item 3 stdole OLE Automation 2 0
Item 4 DAO Microsoft Office 12.0 Access database engine Object Library 12 0
Item 5 Office Microsoft Office 12.0 Object Library 2 4
Item 6 VBIDE Microsoft Visual Basic for Applications Extensibility 5.3 5 3




Print Time: 12:11:51 :: Item - Full Path
Item 1 C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
Item 2 C:\Program Files (x86)\Microsoft Office\Office12\MSACC.OLB
Item 3 C:\Windows\SysWOW64\stdole2.tlb
Item 4 C:\PROGRA~2\COMMON~1\MICROS~1\OFFICE12\ACEDAO.DLL
Item 5 C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE12\MSO.DLL
Item 6 C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB




Print Time: 12:11:51 :: Item - GUID
Item 1 {000204EF-0000-0000-C000-000000000046}
Item 2 {4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}
Item 3 {00020430-0000-0000-C000-000000000046}
Item 4 {4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28}
Item 5 {2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}
Item 6 {0002E157-0000-0000-C000-000000000046}

[isladogs]

As @Welshgasman has indicated, you need to browse for MSO.dll which will be in the folder C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE12\ if you have 64-bit Windows or C:\Program Files\Common Files\Microsoft Shared\OFFICE12\ with 32-bit Windows

[chiefweigum]

Thanks guys - the path to where those files are located really helped. I now have the same 6 as @Welshgasman but some of them look like different versions. With all of these installed, I still get the 31602 error. I feel bad for taking up your time so if you give up, I can live with the extra time it takes me to locate the tasks when I want to run them. Funny, some of them I use more often so I now how much page scrolling I need to do to find them.