I found the reason for the problem. I work with

- Win 7 64bit

- MS SQL Server 2008 R2 64bit

- MS Office 2007 32bit; there is no Office 2007 64bit

I downloaded...

Yes, I copy'n'pasted both text blocks you sent me; unfortunately without success.

Is there an easy way to test, wheter I can connect with Access DB or not? Because my...

Hi sqlsetter

Thanks again for your answer. Unfortunately I get the same error massage as initially. Do I have to install something special?

it's only locally

what do you mean exactly? Is it not possible to adapt the code working with MS Office 2007? I really have to 'downgrade' my Office to Version 2003?

Hi SQLSeTTeR

Thanks for your answer. It must be a problem of different Office-Versions. The above code worked fine with MS Office 2003; but I guess the connection can not be...