>What do you mean by the form stays open in the following sentence: "user A MAKES NO CHANGES to the recordset and then closes it but the form stays open..."
When a user logs in to the app a logical field is set true and the name of the pc they are sat at is stored in a users table... a shutdown routine updates this table when they exit the app. Occasionally I will have the situation where the app crashes and a user will appear logged in but is not. I have made provision for this by creating a user admin form where a administator can reset the info in the users table so...
The exact scenario is this - user A has crashed and starts the app again - he/she gets the message - "User A is already logged on at PC name..." - he/she then asks an administrator to log them out - the process of user A logging in opens an rs of the users table to get this info but is then closed because the data returned shows user A as being logged in BUT the login form remains open while he/she twiddles their thumbs waiting to be cleared...
User B opens the user admin form and presses reset for that user - this opens an rs of the users table and resets the logical flag to false and clears the pc name - then updates the rs and closes it... the administrator then closes the user admin form... tells user A to try loging in again...
User A tries again and then the error occurs...
If I think about it logically - the error should not occur at all because user A's rs is opened when they first attempt to log in then closed - even set rs = nothing!!! - then when they attempt to log in after admin has cleared them, a fresh rs is opened so really it should update without the -2147467259 error at all!!!
THANK YOU SO MUCH FOR YOUR HELP!!!
Also to answer the other question - I am not binding the data to any controls ie. grdGrid.datasource = rsUSers... I am doing it all like this...
txt(0).Text = Trim(rsUsers!us_name) etc etc
Thanks again! It's good to know there are folk there!
Chris