Forum Discussion
Jacob_Porter
Jul 15, 2020Brass Contributor
Having read only access to a group form in Forms
Is it really not possible to add a form to a group and restrict access to group members as read only/fill-able rather than full owner access? If so is it possible for this feature to be added, me...
- Feb 17, 2021
Michael Waters You're the only one who replied.
This is an update from Microsoft this morning, This will resolve my problem.
Thanks Microsoft!
Regards,
J_Porter
Kinkium
Jun 18, 2021Copper Contributor
Jacob_PorterHow about a simple file key, whats in the file doesn't matter, just the fact that it exists.
Not overly secure if a non-admin figures out your method/key etc.
Or may not suit your needs at all but might also give you other ideas for thinking outside the box.
Public Function FileExists(ByVal path_ As String) As Boolean
FileExists = (Len(Dir(FilePathName)) > 0)
End Function
Put the file on the PC who is to be admin.
Then simply on your form.
OnCurrent
If FileExists = True then
Call procedure to Unlock/enable controls
else
Call procedure to Lock/Disable controls
End
The other way is a lot more involved to create log-in forms, tables of usersnames/passwords/permissions etc then its contained within the DB itself.