With the security built into access, it comes with the default security users; "User", & "Admin"
(you can add more of course)
My question is;
Can you progmaticly change the database's security user currently logged in using vba?
For example;
I have code that gets your username from windows. So if "jsmith" opens the database it will set him as "User", and then if "mjohnson" opens the database it sets him to "Admin"
If anyone can help me with this I would apreciate it.
Thanks,
Keith
(you can add more of course)
My question is;
Can you progmaticly change the database's security user currently logged in using vba?
For example;
I have code that gets your username from windows. So if "jsmith" opens the database it will set him as "User", and then if "mjohnson" opens the database it sets him to "Admin"
If anyone can help me with this I would apreciate it.
Thanks,
Keith