Search results

The CurrentUser method returns the value of the userid that's logged into Access (ie. currently it's returning Admin). environ("username") is the userid that's logged into the network. Both of these I learned from the previous posters on this thread. Thanks for that. I can now see what the...

I have that. I'm able to see what the Network ID is, I just don't know how to make that become the userid that the Access database recognizes as the "Current User". It shows "admin" for everyone. I added a picture to help explain. When you open the User Group and Permissions dialog, it shows...

I'm not actually trying to restrict access to the database itself, I'm trying to restrict access WITHIN the database (ie. User and Group Permissions). I want any user who opens the database to be able to view the data. But I only want select users to be able to change things (edit queries...

Thanks so much Mr. B. That does provide me exactly what I asked for. Now for my next step in the problem... How do a make that userid I have just captured be the actual userid that the user is logging into the database with? Or change their current login to be that login? As mentioned...

I have a database that is being used over a network, and rather than set up a userid/password security for my database, I want to just base it on the network userid of the person accessing the database. I can see that Access knows my Network ID, so I just need to have it use my Network ID as...