You can't go to the specified record in access database

  • Thread starter Thread starter Adam Olson
  • Start date Start date
A

Adam Olson

When clicking on a link in an access form one of my users is getting an
error: You can't go to the specified record. He has full windows security
permissions to the file and has full access security to the Workgroup file.
T his is the code for the button:
Private Sub AddCourse_Click()
On Error GoTo Err_AddCourse_Click


DoCmd.GoToRecord , , acNewRec

Exit_AddCourse_Click:
Exit Sub

Err_AddCourse_Click:
MsgBox Err.Description
Resume Exit_AddCourse_Click

End Sub

when i open up this database it works fine. i did not create this database.
 
When I select User and Group Permissions and highlight any users name the
Read Data, Update Data, Insert Data and Delete Data checkboxes are all greyed
out.
 
This user is a member of the Admin group and for every table that group has
insert, read, update and delete permissions. When opening the database
logged on as that user (to the server where the data resides) I am still
getting an error Run-time error '2046': the command or action
'RecordsGoToNew' isn't available now. If I log onto a workstation and access
the database through the network I get an error You do not have the ncessary
permission to use the object. Have your system administrator or the person
who created this object establish the apropriate permissions for you - I even
get this error when logged on with my account that is a domain administrator.
 
Back
Top