MikeAngelastro
Registered User.
- Local time
- Today, 08:13
- Joined
- Mar 3, 2000
- Messages
- 254
Hi,
Is there a way with code to determine the filename of the Access application that a user is in or at least what folder it's in?
The reason is that I want to enable/disable functional modules based on it. For instance, if the file name were "Acctg_Warehouse.mdb," then enable only the modules appropriate to the warehouse folks. If the file name were "Acctg_Sales.mdb," then enable only the modules for the sales folks.
I know it's possible using Access security, but I don't have that option in my situation.
Thanks,
Mike
Is there a way with code to determine the filename of the Access application that a user is in or at least what folder it's in?
The reason is that I want to enable/disable functional modules based on it. For instance, if the file name were "Acctg_Warehouse.mdb," then enable only the modules appropriate to the warehouse folks. If the file name were "Acctg_Sales.mdb," then enable only the modules for the sales folks.
I know it's possible using Access security, but I don't have that option in my situation.
Thanks,
Mike