Database Connection to local Access DB: Not Found or OLEDB not registerd

[Anonymous]

Hello 2 Different approches :

1st . CigarBoxDB.accdb is placed in Projectlocation

but within ODBC connection in the computer I can not apply

a connection to a local MSAcesss File : Error : Driver not Found and

Architecture does not match Environment

'###################
'####ODBC
'#############
    Child DB_Connection As :odbc_Database
	Provider = :ODBC
	dsn = "CigarBoxDB" 
	readonly?=True
	End Child

Error : Database not Found

2nd: Try to connect with connection string

'###################
'####ADO.Net Data Connection
'#############
    Child ADO_table As :ADO_Table
		dataProvider = :OLEDB
		OnNullReturn=RaiseError("No Success on database connection!")
		connectionString =  "Provider=Microsoft.ACE.OLEDB.12.0;Database=G:\Inventor\19_ETO\ETO_TechnologieTransfer2015\" _ 
		& "cigarbox2\CigarBoxDB.accdb;Trusted_Connection=yes;"
		tableName="L_CigarBox"
		color=Me.Colour
	End Child

Error :  Microsoft.ACE.OLEDB.12.0 not registerd

We have 64bit Machine and 32Bit Office. Installed AccessDatabaseEngine.exe 32 and 64 whiles deinstalling them in beetween.

Any has a solution for this ?

Thank you / Regards

Timo

[Anonymous · Accepted solution]

Here is the Solution:

http://techblog.aimms.com/2014/10/27/installing-32-bit-and-64-bit-microsoft-access-drivers-next-to-e...

works now !