After system upgrade WIN10, the original 2007 version of OFFICE one day somehow strange error, modified Offic2016 version, now want to use excel to do in VB6 database, always prompt. DLL errors, for some reason, the ACCESS reference also have the same problem, not the other chart, please master pushing, thank you,

CodePudding user response:

To Microsoft download Microsoft Access Database Engine 2016, installed after try again

https://www.baidu.com/link? Url=uOAySLQOpA1riTchrNrot1xFDraJ7VFGG0QrGKb2w - nYf7NXZAbGEO_siunj3X5PCVOAAt2q1F1Y08HPtWWxd4yDBIfwKDZi 0 dvkhncnug & amp; Wd=& amp; Eqid=ed446c2c00004007000000065c258fd9

CodePudding user response:

Download and install the, the problem is still the same, no problem,

CodePudding user response:

refer to the second floor cyh_119 response:

download and install the problem is still the same, no problem,

Do you see the 2 pictures that prompt, check the file, see which directory,
1. C: \ Program Files \ (x86) Common Files \ Microsoft Shared \ OFFICE12
2. C: \ Program Files \ Common Files \ Microsoft Shared \ OFFICE12

"1" as shown in the above folder, if there is any ACEODEXL. DLL?
If you have, you are searched in the registry "value" : ACEODEXL. DLL
Those who find the tips of the above 2 "path", all changed to "1." I said path,

If not, "2" directory is there? If there is a (very unlikely) here, is that a component does not compatible, can't,

Another possibility:
Folder "OFFICE12" is an component path, and you install "Office 2016",
The path should be a "greater numerical" rather than 12 (specific how many I don't know),
You see how much is your Office specific components, you put the registry corresponding ACEODEXL. DLL path to correct a try,
And that "short path consistent with your system tray not" (" upgrade system "because of you, have a" repeat "can cause ~ 3, or 4, etc.),
'd better change it to "path,"

CodePudding user response:

1. The two directory to find the file, directory under 1 ACEODEXL. DLL is 06 edition, directory under 2 ACEODEXL. DLL latest revision date is 2012, should be two different versions (see chart), but the directory under this version 2 is copied to the directory after I downloaded from the Internet under 2, because the original errors this file does not exist, so the under a tip on the directory and the subsequent how to operate? Delete this download ACEODEXL. DLL? But I think the problem was,
2. Another confusion is that no matter I use 32-bit or 64 - bit ODBC data source management program, show my excel is 32 bit, but in fact I install is 2016 64 - bit version of office, what reason be?

CodePudding user response:

This I don't know,
I didn't use any "database engine" things, installing a VB6 I also remove the many database related components,

File version information, my computer in the DLL in addition to the "time" is difference were with you, the other seems to be the same,
And installed in my computer is a 32-bit 07 version of the directory 1 still has a lot of "similar" DLL,
ACE (* * * *. DLL has 23, there are three "subdirectory" have a lot of files)
You the directory, if only a few dozen files, estimated 07 version of the component is unable to use,
Your installation is 2016, see "C: \ Program Files \ (x86) Common Files \ Microsoft Shared \ OFFICE16"
Is there in the ACEODEXL. DLL...
Maybe you should change the "driver" into 16 version of the component,
(" abnormal "anyway, try the regsvr32/u 07 version of the DLL, and then register the 16th edition of the DLL)

CodePudding user response:

"C: \ Program Files \ (x86) Common Files \ Microsoft Shared ", I saw, this directory no OFFICE16 this folder, only offcie11 and office12 two folders,

CodePudding user response:

refer to 6th floor cyh_119 response:

"C: \ Program Files \ (x86) Common Files \ Microsoft Shared ", I saw, this directory no OFFICE16 this folder, only offcie11 and office12 two folders,

So... This is more trouble...

It may be "incomplete component", because it's definitely not "a DLL is finished,"
And "the database engine" is so complicated, just a DLL that's less than 15 KB is done? No way,
You can try to uninstall the 2016, 2007 try (you can choose not to install Word, useless stuff such as PPT),
If "available", don't unload, directly to install your 2016,
If you still can't use, I also think that other processing method,

CodePudding user response:

Have trouble? Download a Excel 12.0 driver installation once solve the problem, this is Excel drive does not match the main cause of the,

CodePudding user response:

It is ok to use ADO directly reading excel

CodePudding user response:

refer to the eighth floor ZHRXJR response:

have trouble? Download a Excel 12.0 driver installation once solve the problem, this is Excel drive does not match the main cause of the,

Where is the download, can you give a link to seek along while didn't find,

CodePudding user response:

https://download.csdn.net/download/andrezone/6584773

CodePudding user response:

Wow, 48 points 48 c/c... so expensive

Can be downloaded to the official website of M $, free,

CodePudding user response:

Use ADO directly reading excel, like working with databases, you are to say to want to as a data source, and with reference to read to write?