Share Previous-version Secured Database.
With one exception, the issues involved when sharing a secured database across more than one version of Microsoft Access are the same as the issues for sharing an unsecured database across more than one version.
The one exception concerns how to handle the workgroup information file that is used with the secured database. You have two choices:
- Tell users who will be upgrading to Microsoft Access 2000 to join the appropriate workgroup information file with the oldest version of Microsoft Access that will be sharing the secured database.
Microsoft Access 2000 can use workgroup information files that have been created with previous versions, but previous versions can only use workgroup information files that have been created with Microsoft Access 2000 or a previous version.
Important: If users will be sharing a secured database from Microsoft Access 95 or 97, you should compact the current workgroup information file with Microsoft Access 2000 before using it. Compacting the file by using Microsoft Access 2000 does not change the file format, so the file can continue to be used by any Microsoft Access 95 or 97 users who are not upgrading.
- If the shared database is Microsoft Access version 2.0, convert the workgroup information file that will be used with the secured database and then tell only users who are upgrading to Microsoft Access 2000 to join the converted workgroup information file. All users who are not upgrading from version 2.0, must continue to use the workgroup information file produced with that version.
Earlier Post Link References:
-->MS-ACCESS Security Links.
- Create a security user account
- Create a security group account
- Add users to security groups
- Remove users from security groups
- Delete a security user account
- Delete a security group account
- Create or change a security account password
- Clear a security account password
- Assign or remove permissions
- Assign default permissions for new tables, queries, forms, reports, and macros.
- View or transfer ownership of Objects
- Transfer ownership of an entire database to another administrator
- Permit others to view or run my query but not change data or query design.
- Change default permissions for all new queries.
- RunPermissions Property
- Convert Microsoft Access 95 or 97 secured databases.
- Convert a workgroup information file from a previous version of Microsoft Access.
- Share a previous-version secured database across several versions of Microsoft Access
[...] it. You must get a message like 'You have successfully joined the Workgroup Administration file'. Share Previous Version Database __________________ http://www.msaccesstips.com (Learn MS-Access Tips & Tricks) Learn [...]
ReplyDelete