Hi
Hi
As daft as it may sound I have carried out the approach detailed by
Keith Wilby on his site www.keithwilby.com/ down to and inclusive of
import objects. I have established that:
1. IPGAdmin is now a member of the ‘Admins’ group and owns the
database and imported objects.
2. Admin the old user does not own the objects or the database and
does not have any permissions.
So now I have to check that IT has worked. I quote "Check that it has
worked by trying to log on as Admin with the password you gave the
account earlier. You should also check that you can't open the
database from an explorer window".
This is what I have checked and the associated results:
1) Double clicking on the MDB from within Windows Explorer generates a
popup logon. If I enter the original Admin and Password, the Admin
user can still do anything with the objects, delete and create etc.
2) I created a blank database under the original 'Admin' and password
and succeeded in importing all of the tables from the new database
which the 'Admin' user has no ownership or permissions.
Help what have I achieved?
Regards
Carriolan