Access db - autofield

Results 1 to 3 of 3

Thread: Access db - autofield

  1. #1
    Join Date
    Dec 1969

    Default Access db - autofield

    Is it possible to change autofield value of field?I checked in documentation. It says its not possible to change calue of autofield once its assigned. Is there a workaround ?<BR><BR>thanks in advance

  2. #2
    Join Date
    Dec 1969

    Default Heh. Think they lied to you?

    If the documentation says it&#039;s not possible to change, why would you doubt it?<BR><BR>Is it possible to delete it and re-create a new one?

  3. #3
    Join Date
    Dec 1969

    Default RE: Access db - autofield

    Take off the autonumber by changing it to a number. Then put autonumbering back on. I might throw-up, though and tell you that you can&#039;t make it an autonumber field because there is existing data.<BR><BR>Use SQL Server, you can do it there. SET IDENTITY_INSERT OFF or some shiznit like that.<BR><BR>-Doug

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts