two queries

[Dante]

Hi,
Wonder if its possible to execute two queries to Access.
Ex: "INSERT INTO aaa(a_something) VALUES(?);SELECT
@@IDENTITY"

 

[John Vinson]

Hi,
Wonder if its possible to execute two queries to Access.
Ex: "INSERT INTO aaa(a_something) VALUES(?);SELECT
@@IDENTITY"

No - unlike SQL, queries run "solo". In addition, they do not have the
@@IDENTITY operator.