Microsoft KB Archive/241232

= ACC2000: Unable to Import Table When High ANSI Characters Are Used =

Article ID: 241232

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q241232



Advanced: Requires expert coding, interoperability, and multiuser skills.

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



SYMPTOMS
When you try to import objects from a Microsoft Access 97 secured database into a Microsoft Access 2000 database, you may receive the following error message:

You don't have permissions to import, export or link to ' '.



CAUSE
The Access 97 workgroup information file was created with high ANSI characters in the Workgroup ID.



RESOLUTION
Workgroups with high ANSI characters do not exhibit this behavior in Microsoft Access 97 databases. The only known workaround at this time is to change the Workgroup ID in Access 97 so that it does not include high ANSI characters.



STATUS
Microsoft has confirmed that this is a problem in Access 2000.



Create a Database in Access 97
Open the Access 97 Workgroup Administrator (Wrkgadm.exe), located in the Windows\System folder. In the Workgroup Administrator, create a workgroup information file with the following information: UserName: JoeDoe Company: TEST For the Workgroup ID, use the following high ANSI characters:


 * ALT+0182
 * ALT+0224
 * ALT+0188
 * ALT+0196
 * ALT+0194
 * ALT+0201

Start Access and open the Access 97 sample database Northwind.mdb. Create a new user account with the UserName: JoeDoe and add the JoeDoe user account to the ADMINS Group.

For the Personal ID (PID), use the following high ANSI characters:
 * ALT+0182
 * ALT+0192
 * ALT+0200
 * ALT+0201

Quit Access, restart it, and log on by using the new JoeDoe user account with no password. Remove the Admin user from the ADMINS group. Create a new group called Acc97 with the following high ANSI characters for the PID:
 * ALT+0182
 * ALT+0183
 * ALT+0184
 * ALT+0185

Create another new group called Acc97NoHANSI with a PID of 1234. Create a new database called DB1.mdb. Import all the tables from Northwind.mdb into DB1.mdb. Using the User-Level Security Wizard, secure DB1.mdb. Name it Secure DB1.mdb. Open the newly secured Secure DB1.mdb. Give both of the new groups Administer permissions to all the tables, including the system tables. Give both of the new groups Open Run, Open Exclusive, and Administer rights to the database. At this point, both groups should be identical, except for the fact that one has a PID of high ANSI characters. Quit Access 97.

Open the Database in Access 2000
 Use the Access 2000 version of Workgroup Administrator to create a new workgroup information file. Use the UserName, Company, and Workgroup ID that you used in step 2 of the "Create a Database in Access 97" section. Start Access 2000 and create a new user called Joe2000 with the following high ANSI characters for the PID:  ALT+0182 ALT+0192 ALT+0200</li> ALT+0201</li></ul>

NOTE: These are the same high ANSI characters used to create the group in Access 97.

</li> Create a new group called Acc97 with the following high ANSI characters for the PID: <ul> ALT+0182</li> ALT+0183</li> ALT+0184</li> ALT+0185</li></ul>

</li> Create another new group called Acc97NoHANSI with a PID of 1234.NOTE: This also is the same name and PID used with Access 97.

</li> Make Joe2000 a member of the group Acc97.</li> Give Admin a password.</li> Quit Access 2000 and restart it.</li> Log on as Joe2000 and create a new database.</li> On the File menu, point to Get External Data, and then click Import.</li> Select the Secure DB1.mdb and try to import a table.</li> Note that you receive the error message:

You don't have permissions to import, export or link to ' '

</li> If you move the Joe2000 user account to the Acc97NoHANSI group, you can import the objects, and you won't receive the error message.</li></ol>

<div class="references_section">