http://www.vbex.ru/index.php?action=history&feed=atom&title=VBA%2FExcel%2FAccess%2FWord%2FAccess%2FPrimary_Key
VBA/Excel/Access/Word/Access/Primary Key - История изменений
2026-04-06T22:16:38Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.vbex.ru/index.php?title=VBA/Excel/Access/Word/Access/Primary_Key&diff=1278&oldid=prev
в 16:33, 26 мая 2010
2010-05-26T16:33:00Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 16:33, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://www.vbex.ru/index.php?title=VBA/Excel/Access/Word/Access/Primary_Key&diff=1279&oldid=prev
Admin: 1 версия
2010-05-26T12:46:44Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Adding a Primary Key to a Table with SQL command==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="vb"><br />
<br />
Sub AddPrimaryKey() <br />
Dim conn As ADODB.Connection <br />
Dim strTable As String <br />
Dim strCol As String <br />
On Error GoTo ErrorHandler <br />
Set conn = CurrentProject.Connection <br />
strTable = "myTable" <br />
strCol = "Id" <br />
conn.Execute "ALTER TABLE " & strTable & " ADD CONSTRAINT pKey PRIMARY KEY(" & strCol & ");" <br />
ExitHere: <br />
conn.Close <br />
Set conn = Nothing <br />
Exit Sub <br />
ErrorHandler: <br />
Debug.Print Err.Number & ":" & Err.Description <br />
Resume ExitHere <br />
End Sub <br />
</source><br />
<br />
<br />
<br />
<br />
==Create a primary key==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="vb"><br />
<br />
Sub ADOCreatePrimaryKey()<br />
Dim cat As New ADOX.Catalog<br />
Dim tbl As ADOX.Table<br />
Dim pk As New ADOX.Key<br />
<br />
cat.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _<br />
"Data Source=C:\mydb.mdb;"<br />
<br />
Set tbl = cat.Tables("Newtable")<br />
pk.Name = "PrimaryKey"<br />
pk.Type = adKeyPrimary<br />
pk.Columns.Append "Column1"<br />
tbl.Keys.Append pk<br />
End Sub<br />
</source><br />
<br />
<br />
<br />
<br />
==Creating a Primary Key==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="vb"><br />
<br />
Sub Create_PrimaryKey()<br />
Dim cat As New ADOX.Catalog<br />
Dim myTable As New ADOX.Table<br />
Dim pKey As New ADOX.Key<br />
On Error GoTo ErrorHandler<br />
cat.ActiveConnection = CurrentProject.Connection<br />
Set myTable = cat.Tables("vbexTable")<br />
With pKey<br />
.Name = "PrimaryKey"<br />
.Type = adKeyPrimary<br />
End With<br />
pKey.Columns.Append "Id"<br />
myTable.Keys.Append pKey<br />
Set cat = Nothing<br />
Exit Sub<br />
ErrorHandler:<br />
If Err.Number = -2147217856 Then<br />
MsgBox "The "vbexTable" is open.", _<br />
vbCritical, "Please close the table"<br />
ElseIf Err.Number = -2147217767 Then<br />
myTable.Keys.Delete pKey.Name<br />
Resume<br />
Else<br />
MsgBox Err.Number & ": " & Err.Description<br />
End If<br />
End Sub<br />
</source><br />
<br />
<br />
<br />
<br />
==Creating a Single-Field Primary Key with SQL command==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="vb"><br />
<br />
Sub SingleField_PKey()<br />
Dim conn As ADODB.Connection<br />
Dim strTable As String<br />
On Error GoTo ErrorHandler<br />
Set conn = CurrentProject.Connection<br />
strTable = "myTable"<br />
conn.Execute "CREATE TABLE " & strTable _<br />
& "(SId INTEGER, " _<br />
& "SName CHAR (30), " _<br />
& "CONSTRAINT idxPrimary PRIMARY KEY " _<br />
& "(SId));"<br />
Application.RefreshDatabaseWindow<br />
ExitHere:<br />
conn.Close<br />
Set conn = Nothing<br />
Exit Sub<br />
ErrorHandler:<br />
MsgBox Err.Number & ":" & Err.Description<br />
Resume ExitHere<br />
End Sub<br />
</source></div>
Admin