I have an access 2002 application, I'm using ADODB to insert a record into a table in a SQL Server 2000 backend. I am using a connection object and a recordset object.
The code for works fine for 40 users, but simply will not work for 2 particular people.
When I step through the code as these users I see that the recordset never opens, I have tested my connnection object at this point and it is open.
At the point below the recordset does not open.
Set rs = New ADODB.Recordset
rs.Open strSQL, dbRDDTCnn, adOpenDynamic, adLockOptimistic
I cannot fathom why vba code that works perfectly for so many people would not work for just two people.
I would be very grateful for any suggestions you might have