Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Generating the next sequential key...
timasmith_at_hotmail.com wrote:
> Please correct me if MSAccess has progressed beyond that.
Sub temp()
Dim c As ADODB.Connection
Set c = New ADODB.Connection
With c
.ConnectionString = CurrentProject.BaseConnectionString .Open .Execute "INSERT INTO [Order Details] " _& "(OrderID, ProductID, UnitPrice, Quantity, Discount) " _ & "Values (12, 23, 15.5, 12, 3/1000)"