How can I change an Identity field ( Auto Number ) to an integer

[essa2000]

Dears;
I am working on a 3-tier application and I am using a disconnected Rs to bound a Grid . I want to add a new record in this RecordSet. But , the problem is that my table from which this RecordSet is generated have a Primary Key which is a Auto Number Field. When , I try to call the AddNew Method it gives error "Errors Occured".
RecordSet is set to CursorLocation = AdUserClient
LockType = adBatchOptimistic and CursorType is adStatic.

I have dumped that recordSet in a Temp table using Select Into statement and fetched records from that table but it also has that Auto Number structure in a Stored Procedure.

I have also converted that Rs into other new updateable recordset but it affects the behaviour of that grid with which it is bound.

So , how can I solve this Problem.



Regards,
Essa