T
Tim
How do I change permissions so a non-admin user can import
tables, queries, forms, reports and modules? This all
needs to be done in code with no interaction from the user.
I have a front-end db that is subject to ongoing
development and upgrade whilst live. Each client front-end
has a Version number. When the user logs in, the database
compares the version number to a table on the backend
which lists all the available objects and their individual
version numbers. Any back-end objects with higher version
numbers are selected, the existing object in the front-end
is deleted and the object from the backend is imported.
This all happens invisibly whilst a splash screen is
displayed.
This works fine for Admin users, but regular users do not
have permission to import the objects (or read the custom
datavbase property "Version" that I created). How do I
give them this permission and then remove it once the
update routine is complete?
tables, queries, forms, reports and modules? This all
needs to be done in code with no interaction from the user.
I have a front-end db that is subject to ongoing
development and upgrade whilst live. Each client front-end
has a Version number. When the user logs in, the database
compares the version number to a table on the backend
which lists all the available objects and their individual
version numbers. Any back-end objects with higher version
numbers are selected, the existing object in the front-end
is deleted and the object from the backend is imported.
This all happens invisibly whilst a splash screen is
displayed.
This works fine for Admin users, but regular users do not
have permission to import the objects (or read the custom
datavbase property "Version" that I created). How do I
give them this permission and then remove it once the
update routine is complete?