Db-why-not
Registered User.
- Local time
- Today, 02:07
- Joined
- Sep 17, 2019
- Messages
- 160
I have a front end and backend database with userid and logins. I have the backend tables saved on the network shared drive. I have a front end version that will connect to the backend.
The pathway to the shared folders is different for different users. When I link the backend files to front end, it works for me but then the the backend wont work for other users because it doesn't recognize the pathway
My pathway to SOP folder: Example G:\adfg\SGA\3)transition\sop
coworkers pathway to SOP folder G:\SGA\3)transition\sop
They get an error message about the file pathway not being correct. The file pathway is correct for myself but not for my coworkers.
My coworkers are able to access the same SOP folder as me, they have permission.
How do I fix the pathway for my coworkers? I know that I can make multiple front ends with the proper pathways linking the backend. I don't have that pathway on my computer to link the backend to "G:\SGA\3)transition\sop".
There is also the issue with my login and password. In order for you to change how the backend data is linked you have to login to the database with userid and password and then you can modify the links. Once Someone changes the links to this pathway G:\SGA\3)transition\sop I will no longer be able to login to that frontend version.
Just trying to figure out the best solution to this. I already converted this db to a accde file. I could use my masterfile, remove the login page and have my coworkers fix the linked backends, then add the login form back to the file and reconvert it back to a Accde file. I was hoping there was an easier solution to this issue? I don't want to have my coworkers to have to link the backend data. I should be the only one having to do that. IF there is any updates I will have to do this all over again.
The pathway to the shared folders is different for different users. When I link the backend files to front end, it works for me but then the the backend wont work for other users because it doesn't recognize the pathway
My pathway to SOP folder: Example G:\adfg\SGA\3)transition\sop
coworkers pathway to SOP folder G:\SGA\3)transition\sop
They get an error message about the file pathway not being correct. The file pathway is correct for myself but not for my coworkers.
My coworkers are able to access the same SOP folder as me, they have permission.
How do I fix the pathway for my coworkers? I know that I can make multiple front ends with the proper pathways linking the backend. I don't have that pathway on my computer to link the backend to "G:\SGA\3)transition\sop".
There is also the issue with my login and password. In order for you to change how the backend data is linked you have to login to the database with userid and password and then you can modify the links. Once Someone changes the links to this pathway G:\SGA\3)transition\sop I will no longer be able to login to that frontend version.
Just trying to figure out the best solution to this. I already converted this db to a accde file. I could use my masterfile, remove the login page and have my coworkers fix the linked backends, then add the login form back to the file and reconvert it back to a Accde file. I was hoping there was an easier solution to this issue? I don't want to have my coworkers to have to link the backend data. I should be the only one having to do that. IF there is any updates I will have to do this all over again.
