Hello experts!
I am working with a db placed in a Sharepoint server, so every user that needs to use it has a Front-End (Access .mdb file). Once they open the file, a window appears using Access' security, each user logs in, and they can see the different forms, tables, and so on.
The issue is, when they need to work with a table, first time a table is opened Sharepoint prompts authentication.
I would like to know: Is there any way to workaround this authentication window, using the current user and pass?
I have been trying using a form at the beggining, so it gets the current user with CurrentUser(), it checks for this user in a table, gets the pass, but don't know how to establish a connection with the server using this pair user/pass.
Could you help me?
Thanks in advance
I am working with a db placed in a Sharepoint server, so every user that needs to use it has a Front-End (Access .mdb file). Once they open the file, a window appears using Access' security, each user logs in, and they can see the different forms, tables, and so on.
The issue is, when they need to work with a table, first time a table is opened Sharepoint prompts authentication.
I would like to know: Is there any way to workaround this authentication window, using the current user and pass?
I have been trying using a form at the beggining, so it gets the current user with CurrentUser(), it checks for this user in a table, gets the pass, but don't know how to establish a connection with the server using this pair user/pass.
Could you help me?
Thanks in advance
