Change a Database from Private to Public
To change a database from private to public, and vice versa, you must have the Security privilege, which is necessary to use the accessdb utiility.
To change a database from private to public, or vice versa
1. Issue this command at the operating system prompt:
accessdb
The accessdb forms-based utility starts.
2. Select Databases from the menu.
The list of databases in the installation appears.
3. Select the database for which you want to change the access, and then select Access from the menu.
The Database Access frame appears.
4. Tab to the Default Access field. Type private over public (or public over private).
5. If you changed the access from public to private, tab to the User Name tablefield, and enter the logins of the users who you want to access this database. Remember to enter your (the DBA’s) login.
6. Select Save from the menu.
The logins you entered are saved.
7. Select Quit.
The accessdb utility closes.
Last modified date: 01/30/2023