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
After a bit of help regarding an access query (access 97
![Frown :( :(](/styles/default/xenforo/vbSmilies/Normal/frown.gif)
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