IIS + ODBC + Another Sever + Access DB

My website on IIS server and my Access Data base in shared folder on another server how to connect my IIS to that data base by using ODBC connection?

Look at this scenario:
My MS Access Data base on server (B) in a shared folder, and I want to connect my web server to it by using ODBC Driver.
My question is: How can I give permission to my web server to be able to access that data base, which on server B.
Please help me!

did you try making a virturl file/folder in your IIS manerger? if you did and you are still having troble then you might have to wait for someone else to come a long and help you out.

you have to create new System DSN in the ODBC, point your dsn to the mdb file on the network, and use the dsn when connecting.
on the file itself and its folder, give read/write permissions for Internet User account.

Thanks "Borgis1" for you kind help, but this sulotion, i don't want to give permission to a certain user, because if I want to create a virtual directory. I will have to supply my domain user name and password. put if I change my password later, what will happen then, or if I resign some confusing will happen?! So I need solution that not depend on cretin user privilege, is it passable to give certain serves a privileges to have the authority?

Thanks "Shadow Wizard" for your help,

but this is not the efficient solution, because, if I log out from the server, the connection well by broken. This the problem ………I know, it is very complex



thanks a gain,

Ricab

there is no efficient or not efficient issue here... any connection would be "broken", as it should be, once user not connected anymore - unless you store the connection object itself, opened, in the application scope.