Get the last added records ID

[lechuck]

I have a table MyTable that contain too columns: Col1 that stores chars and a ID column configured as a counter. I did a test on SQL7.0 Server with the following code:

INSERT INTO MyTable(Col1)
VALUES('MyValue')
SELECT @@IDENTITY AS 'NewID';

It insert MyValue into table MyTable, then it returs the new ID of MyValue.

Now I tried the same code against a exact same Table in a Access database, but i get the error message:
Semicolon missing at the end of the SQL-expression.

What shall I do to get the SQL question to work against Access?

Regards
LeChuck

 

[Aivars]

Hi, LeChuck!

Create trying Append (Insert) query based on needed table by using Access Query builder in design window. Then look at SQL window of Query builder for right SQL syntax.

Aivars