What is the difference between ADOX,ADODB and Microsoft.Office.Interop.Access?

Question

.NET

What is the difference between ADOX,ADODB and Microsoft.Office.Interop.Access ?

What is better to use for working with Access database? For example, I need to create a hidden table.

It seems that ADOX+ADODB gives the same functionality as Microsoft.Office.Interop.Access.

Answer 1

ADOX and ADODB works without installing Microsoft Office.
To use Microsoft.Office.Interop.Access, the office installation is required and the Access process is used to work with the database.