ODBC failure - ACCESS DATABASE PERMISSIONS

[Divisadero]

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

[si_the_geek]

Due to the way that Access databases work, the users need to have permission to create/edit/delete files in the folder that the database file is in (even if they are only reading data and not adding/editing/deleting any).

[Divisadero]

Thanks for reply! But they do have rights to do anything they want to the database. That is what is weird... Any idea? What kind of permissions they need?

Thank you again!

[si_the_geek]

They need permissions for the database file, the folder that it is in, and if apt the Shared folder too.

[Divisadero]

They have all mentioned - still doesnt work!

[si_the_geek]

Well in that case, we'll need more details about what the actual problem is - such as what error(s) occur, and what code is running at the time.

[Divisadero]

Thank you! I really appreciate your help! The problem is, that there is actually no big code running. The same problem occurs when I create pivottable from external source manually (not by code). I can refresh pivottable. A workmate of mine from another department cant refresh this table! Even though he can enter the database and do whatever he wants.

I have no idea what is the problem. And our IT department as well :/

The problem - error ODBC failure - err.number 1004

Thank you a lot