Eight steps to resolve access AutoNumber problems (Convert SQL SERVER 2000 databases to access databases) _access

The first step: Open your "Start menu", open "program"-SQL Server Enterprise Mananger "Enterprise Manager"
In the SQL database you want to export, right-click menu: All Tasks-"Export data"

Step Two: An Export wizard window will appear.
Select the exported data source, for the database you have just chosen, if found does not correspond to its own modification.

Step three: Go to the choice of exporting to the target data source, where we'll go to the database for access. Note Selecting the data source type is Microsoft Access. Click the button behind the filename (F) to select the target. MDB file.

Step Fourth: Select Copy tables and views from database.

Fifth step: We note that there is a "conversion" column on the right side of the table selection. SQL export converts only data types regardless of other scripts so the AutoNumber problem we're encountering is here. There is a certain point of automatic numbering select "Convert".

Sixth step: We see a Column Mapping and Transformation dialog box back. Noticed that the self increasing of the EmployeeID int has become a long in access. This is definitely not true, long is not automatic numbering, had to modify the build table script, the picture on the Red circle button "edit SQL."

Open a small window create Talbe

The script in the red circle is the EmployeeID Access table script, preceded by "not NULL" with "IDENTITY (1, 1)".

Step seventh: Execute now.

The following figure indicates that the table replication was successful

Eighth Step: We open the MDB file to see if we like it?

OK, congratulations on your successful operation.