Microsoft KB Archive/295253

= ACC2002: Unable to Convert an Enabled Workgroup Information File After Adding Users =

Article ID: 295253

Article Last Modified on 9/26/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q295253



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
Microsoft Access 2002 allows you to enable and add additional users to a Microsoft Access 97 workgroup information file (.mdw). However, you are prevented from converting the file to Access 2000 or 2002 format. In this case, the Convert Database Into dialog box remains open even if you click Save, and no converted file is saved to the hard disk. On the rare occasion that a file is created, the new file is corrupted, and you receive the following error message; then, Microsoft Access quits:

Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.



RESOLUTION
Currently there is no workaround for the behavior. If you have a workgroup information file that was created prior to Jet 4.0, Microsoft recommends that you re-create the workgroup information file using Jet 4.0.

For more information about re-creating workgroup information files, click Microsoft Access Help on the Help menu, type Troubleshoot Security in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned. Then select the topic I want to rebuild a workgroup information file from user and group names and IDs.

If business needs prevent you from re-creating the workgroup information file with Jet 4.0, you have the following options when working with the original Jet 3.5 workgroup information file.




 * Convert the .mdw file.
 * Leave the file in the format of the earlier version.



Steps to Reproduce the Behavior

 * 1) Make a copy of a Microsoft Access 97 .mdw file.
 * 2) In Microsoft Access 2002, open the copied version of the .mdw file.
 * 3) In the Convert/Open Database dialog box, click Open Database. This will enable the database but maintain the original file format.
 * 4) Close the enabled file.
 * 5) On the Tools menu, point to Security, and then click Workgroup Administrator.
 * 6) Join the enabled copy of your workgroup information file.
 * 7) On the Tools menu, point to Security, and then click User and Group Accounts.
 * 8) Create a new user, and then click OK.
 * 9) On the Tools menu, point to Security, and then click Workgroup Administrator.
 * 10) Create a new work group or join your original workgroup information file.
 * 11) On the Tools menu, point to Database Utilities, and then click Convert Database.
 * 12) Click Access 2000 File Format.
 * 13) Select your enabled copy of the Access 97 workgroup information file.
 * 14) Choose a new destination name, and then click Save.

Note that the dialog box remains open and that, to close the dialog box, you have to click Cancel.

