P
Peter Jamieson
Can anyone point me to any online documentation available for the Ace
database engine and/or specifically the ACE OLE DB provider and ACE ODBC
driver?
I couldn't find much (hardly anything in fact) on MSDN or the Microsoft
Office site.
I am mainly interested in any changes to the way the Provider or Driver work
when programming Word to use data sources such as Access, Excel and so on.
Specifically, if anyone has the answers to the following to hand, could they
please let me know.
a. where does ACE look in the Windows registry for its default Engine
settings - it looks as if there is an equivalent of
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\
at
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access\Access Connectivity
Engine\Engines
but it only contains a "SystemDB" value on my Office 2007 system.
Does it perhaps share the Jet settings? Or does it use the above "Access
Connectivity Engine" entry by default, then fall back to the Jet 4.0 values?
I can research this further but wondered if someone in here just knows the
answer.
b. are there any changes to the connection string or registry settings that
control the behaviour of the Provider when it gets data from Excel. i.e. in
Jet, the connection string IMEX=0 (or IMEX=1 etc.) and the Registry values
TypeGuessRows and ImportMixedTypes are used. I shouldn't thing anything has
changed (except that the Provider can now work correctly with .xslx type
files) but if anyone has come across anything...
Thanks,
Peter Jamieson
database engine and/or specifically the ACE OLE DB provider and ACE ODBC
driver?
I couldn't find much (hardly anything in fact) on MSDN or the Microsoft
Office site.
I am mainly interested in any changes to the way the Provider or Driver work
when programming Word to use data sources such as Access, Excel and so on.
Specifically, if anyone has the answers to the following to hand, could they
please let me know.
a. where does ACE look in the Windows registry for its default Engine
settings - it looks as if there is an equivalent of
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\
at
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access\Access Connectivity
Engine\Engines
but it only contains a "SystemDB" value on my Office 2007 system.
Does it perhaps share the Jet settings? Or does it use the above "Access
Connectivity Engine" entry by default, then fall back to the Jet 4.0 values?
I can research this further but wondered if someone in here just knows the
answer.
b. are there any changes to the connection string or registry settings that
control the behaviour of the Provider when it gets data from Excel. i.e. in
Jet, the connection string IMEX=0 (or IMEX=1 etc.) and the Registry values
TypeGuessRows and ImportMixedTypes are used. I shouldn't thing anything has
changed (except that the Provider can now work correctly with .xslx type
files) but if anyone has come across anything...
Thanks,
Peter Jamieson