I've used the following code to automatically refresh table links.
strCONN = ";DATABASE=" & strPATH & "MyDB_BE.mdb"
For Each tdf In CurrentDb.TableDefs
If tdf.Connect <> "" Then
tdf.Connect = strCONN
tdf.RefreshLink
End If
Next
It works fine for members of the Admin group, but all others get an error 3303 "no permissions for the table" however, the affected group does have permission.
I used a database password and appended ";PWD=" & password to the front of the variable strCONN. And I have removed the password. I used userlevel security on the B/E (the same as the one used on the F/E). And I reverted back to the unsecure BE.
Still I cannot get different user groups to refresh links to the B/E due to this error.
Any help would be appreciated.
strCONN = ";DATABASE=" & strPATH & "MyDB_BE.mdb"
For Each tdf In CurrentDb.TableDefs
If tdf.Connect <> "" Then
tdf.Connect = strCONN
tdf.RefreshLink
End If
Next
It works fine for members of the Admin group, but all others get an error 3303 "no permissions for the table" however, the affected group does have permission.
I used a database password and appended ";PWD=" & password to the front of the variable strCONN. And I have removed the password. I used userlevel security on the B/E (the same as the one used on the F/E). And I reverted back to the unsecure BE.
Still I cannot get different user groups to refresh links to the B/E due to this error.
Any help would be appreciated.