PRB: Random AutoNumber Error After You Export v 7.0/97 to 2.0

Article ID: Q141110
Creation Date: 11-DEC-1995
Revision Date: 06-JAN-1997

The information in this article applies to:

Microsoft Access versions 2.0, 7.0, 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

If you export a table with a random AutoNumber data type field from a Microsoft Access 7.0 or Microsoft Access 97 database to a Microsoft Access 2.0 database, you may receive the following error message when you try to add data to the table in Microsoft Access 2.0:

   Unknown function 'GenUniqueID' in validation expression or default
   value on 'Autonumber.<fieldname>'.

CAUSE

The random AutoNumber data type is not supported by Microsoft Access 2.0.

RESOLUTION

In Microsoft Access 7.0 or Microsoft Access 97, change the field's data type to Number before you export the table to a Microsoft Access 2.0 database.

MORE INFORMATION

Steps to Reproduce Behavior

 1. Start Microsoft Access 7.0 or Microsoft Access 97.

 2. Create the following new table and called it Table1:

       Table: Table1
       ---------------------------
       Field Name: ID
          Data Type: AutoNumber
          Field Size: Long Integer
          New Values: Random
       Field Name: FName
          Data Type: Text

 3. Save and close Table1.

 4. On the File menu, click Save As/Export.

 5. In the Save As dialog box, click "To an external File or Database,"
    and then click OK.

 6. In the Save Table 'Table1' dialog box, click Save Microsoft Access
    (*.mdb, *.mdw, *.mda) in the Save As Type box, locate a 2.0
    database, and then click Export.

 7. In the Export dialog box, click OK.

 8. Start Microsoft Access 2.0.

 9. Open the database that contains the exported Table1 table.

Open the Table1 table in Datasheet view.

Try to type text in the Fname field. Note that you receive the
    following error message:

       Unknown function 'GenUniqueID' in validation expression or default
       value on 'Table1.ID'.

REFERENCES

For more information about the AutoNumber data type, search the Help Index for "Autonumber," or ask the Microsoft Access 97 Office Assistant.

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.