HELLO EXPERTS!

I really need your help.

I have an access database and excel. This excel has VBA code, which automatically generates ODBC connection (to the access dtb) depending on who is logged in to the computer. (This is because everybody needs different data from access database. And I can´t use pivot table for this.)

My problem is, that it works only in my department. Because of different permissions this wont run on other computers outsime my team. I have no idea what to do. I´ve read many articles, but none says anything about persmissions. My IT department has no idea either.

It is not the problem of code for sure! I´ve created pivottable from external sources - linked to the access. Neither this helped. But when I use an account of one of my colleagues and create new mdb and then I link excel to this access it works fine. So it is deffinitely the problem of permissions. And the code does work inside my team. And what is even more weird, colleagues can actually open the mdb file and use it. But connection doesnt work.

Dont you have an idea where is the problem?

Thank´s you a lot!

Sincerely

Divisadero