Acesss query help

Soldato
Joined
21 Nov 2002
Posts
5,011
Location
Manchester
Hi all,

After a bit of help regarding an access query (access 97 :( )

Have two queries one that retrieves the top row into another table and the second that deletes the row from the main table that was retrieved.

At the moment two queries called by vb code run to do this, however between retrieving and deleting it is possible for someone else to retrieve the same row as multiple users will be using the database.

Any ideas how to do this? in sql view it would appear you cannot combine the two by simply pasting the code and im pretty sure you cant lock rows in access 97 so i dont know what to do.

Cheers for any advice
 
thats what im doing, deleting by the work_id of the record retrieved.

unfortunatly because I cant combine the insert into and delete queries into one transaction or query people are still able to retrieve duplicate records if they click between when the two queries are running :(
 
Back
Top Bottom