<div>
in vba, you can use<br />
<br />
currentdb.Execute &quot;Alter table tableName add column newID counter&quot;<br />

</div>


in vba, you can use

currentdb.Execute "Alter table tableName add column newID counter"


<div>
Clarifying... If you define the field as Autonumber inside Access, any new records created through your VB.Net interface will automatically be assigned a unique number.
</div>


Clarifying... If you define the field as Autonumber inside Access, any new records created through your VB.Net interface will automatically be assigned a unique number.

<div>
With Autonumber isn't this an incrementing number for the table and not for the database as in MSSQL.<br />
<br />
Best Regards<br />
Lee
</div>


With Autonumber isn't this an incrementing number for the table and not for the database as in MSSQL.

Best Regards
Lee

<div>
Yes. &nbsp;My understanding of the newID() function is that it will return a totally unique alpha-numeric &quot;number&quot;, and it will never be repeated within that database (or on that computer?). &nbsp; &nbsp;AFAIK, Access has nothing like that. &nbsp;The closest is the Autonumber, which &nbsp;is unique for that table.
</div>


Yes.  My understanding of the newID() function is that it will return a totally unique alpha-numeric "number", and it will never be repeated within that database (or on that computer?).    AFAIK, Access has nothing like that.  The closest is the Autonumber, which  is unique for that table.

<div>
@ ragoran:<br />
That's a great workaround!
</div>


<div>
@mbizup:<br />
<br />
thanks for the good word<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Like in MSSQL you can create new unique ID's using newID() is there a way to do this in an access database.<br />
<br />
Many Thanks<br />
Lee
</div>
</div>


Hi,

Like in MSSQL you can create new unique ID's using newID() is there a way to do this in an access database.

Many Thanks
Lee

Unique ID's in an access database using vb.net

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.