ADOX and Newer Access Versions

[Owen]

Have coded my application using ADOX to iterate through tables within 2
MSAccess files looking for differences. Works well against MSAccess 2000,
2002 and 2003 files, but not 2007.

If I were to take the newer msadox.dll file off my other machine that has
MSAccess 2007 installed, and copy this file onto my current machine,
overwriting my existing and older version, then registering the dll, would
this allow me to run my application on *.accdb (V2007) files, or would it
cause instability issues with other applications (including msaccess 2000) on
my current machine?

Thanks in advance for any advice

[Ralph]

"Owen" <Ow...@discussions.microsoft.com> wrote in message
news:43408544-3075-4396...@microsoft.com...

No. (Well maybe, but doubtful)

Never willy-nilly manually swap in or out data access components. That is
the straightest road to Dll H*ll I know of. Always use an install package.

First off, as answered in your other post, you need to use a separate OLE DB
provider for accessing the newer ACE DB (accdb) format.
Provider=Microsoft.ACE.OLEDB.12.0

Second, MSAccess 2007 comes with a suite of these components on the CD which
you can install separately (though uncertain about the license
requirements). Or you can download the required components from MSDN.

-ralph

[Owen]

Found the required file on microsoft.download.com - thanks Ralph, things are
working excellent now! :)
Owen