Access 2007

[The Little Guy]

I am running this query on Access 2007:

 

insert into tblArTransDetailTemp (transId) values ((select max(transId)+1 from tblArTransDetail));

 

And I am getting this error:

Query input must contain at least one table or query.

 

I have no Idea what is wrong, the tables, exist, the columns exist. The sub select works by its self, the insert works by its self, why don't they work as one?

 

What could be wrong?

[Adam]

Very late response, but only just spotted this thread. You fix the issue? I suspect Access' rubbish error handling was a red herring, and that the problem is you aren't able to use a sub-query on the same table when inserting into it.