ADO 2.8 Write to Record Problem ( Read only Error )

[Irish_Griffin]

Gents,
Good morning, I come to you in my time of need !!

I just proudly launched a new excel form in the office that automaticaly databases the infomation into a .mdb file on my share drive.

Despite my best efforts in beta testing, an issue has arrised that has me baffeled !!


Of all of my users, one individual is not able to write to the database. He connects, generates a connected recordset, but when the code attempts to write to the recordset, he gets a "This Record is Read Only" error.

I take the same file to any other computer, run the upload function and it works fine......

What is going on ? I'm hoping it has to to do with the settings used in the rs.open command.

Attached you will find an example of my upload method.

sub example
 
Dim SQL_Text as String
Dim user_email as String
Dim Connection_String As String
 
 
Dim RS As ADODB.Recordset
Set RS = New ADODB.Recordset
 
 
Connection_String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=R:\FBE_CAD\FBE_Change_Database.mdb"
user_email = "[EMAIL="me@mycompany.com"]me@mycompany.com[/EMAIL]"
SQL_Text = "SELECT * FROM change_details WHERE [request_id] = 12345" 
RS.Open SQL_Text, Connection_String, adOpenStatic
 
RS!user_name = user_email  '  <---- ERROR OUT HERE
 
RS.Update
 
end sub

Many thanks,
Griff

 

[Irish_Griffin]

Solved

Guys,
I found the problem !!

The user in question only has read rights to the share drive !!! NOT MY CODE !!

Phew, launches are stressful !!!

Peace,
-Griff