I am not sure if this is the correct forum or not, but I am having some permission issues problems.
I created an Access .ADP project and everything works great. The last step is setting up the correct permissions for the users. The permissions are simple, full rights on all the database objects for the users. I was wondering if there was a way to set these permissions through the Access front-end?
It would make the whole process much easier to set the permissions on the front-end, so if the back-end needs to be moved, the permissions are still set correctly on the front-end. If not then I will be writing a SQL script to set the permissions on the back-end SQL side.
If anyone has set permissions before, any advice you have would be very beneficial.
Thank you for your time,
T.J.
I created an Access .ADP project and everything works great. The last step is setting up the correct permissions for the users. The permissions are simple, full rights on all the database objects for the users. I was wondering if there was a way to set these permissions through the Access front-end?
It would make the whole process much easier to set the permissions on the front-end, so if the back-end needs to be moved, the permissions are still set correctly on the front-end. If not then I will be writing a SQL script to set the permissions on the back-end SQL side.
If anyone has set permissions before, any advice you have would be very beneficial.
Thank you for your time,
T.J.
