vb6-ms access returns "OPERATION MUST USE AN UPDATEABLE QUERY" errror

Dim ConStr As String
Set Con = New ADODB.Connection
ConStr = "Provider=Microsoft.jet.OLEDB.4.0; " + " Data source=\\dbsrv\HR\db\db1.mdb;"

Set RsEmp = New ADODB.Recordset

 RsEmp.LockType = adLockOptimistic
 RsEmp.CursorLocation = adUseClient
 RsEmp.CursorType = adOpenKeyset
 RsEmp.Open "select * from tb1", Con

the database is stored in  a shared directory HR from the computer DBSRV! the update query only works when run locally, but produces an error message "operation must use an updateable  query" if run from anyother computer in workgroup.
both administrators and  users groups were assigned  full control access to the HR directory however i am still getting  the same error message! so can anybody help fix it?

thanks


winklezAsked:
Who is Participating?
 
irudykConnect With a Mentor Commented:
Hmmm...have you tried to open the mdb file from this other computer (i.e. using Access) to see if it can be opened directly?  If you can do that then it is not likely a network security rights issue.  If you can open the file, can you get intot the tb1 table and make changes to the data.  If you can't then it would appear that it is a user level security issue on the table within the mdb file.
0
 
irudykCommented:
Try adding
Con.Mode = 3      '3 = adModeReadWrite
after
Set Con = New ADODB.Connection

e.g.
Dim ConStr As String
Set Con = New ADODB.Connection
Con.Mode = 3      '3 = adModeReadWrite
0
 
winklezAuthor Commented:
setting the Con.Mode to 3  could not fix it!
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
irudykCommented:
You mentioned "both administrators and  users groups were assigned full control access to the HR directory".  Just curious, does the 'db' folder inherits its permissions from the parent (or 'HR') folder?  If it does, then try giving full rights to the computer object itself (i.e. the computer name that is having the issue) to see if that does anything.
0
 
winklezAuthor Commented:
yeah it does, the DB inherits permissions from HR!  so how do i give the full rights to the computer objects? is it similar to assign rights to users? i.e through  HR directory properties security tab, add users,? i am working in work-group environment, how do u locate the computer object?  thanks
0
 
irudykCommented:
When you click the Add button the dialog box that pops up should have an Object Types.... button.  When you click on that button another dialog box appears where you should be able to check offf Computers.  From there you should be able to enter/search for the computer name.
0
 
winklezAuthor Commented:
did try but the same error message persists!
0
 
winklezAuthor Commented:
never give up, actually, as stated above by irudyk, it was a network security issue.
1> share permissions were set set to change
2> from the host, the user guest was enabled,  added the security tab of HR folder and guaranteed the 'write" permission

 irudyk, thank u very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.