• Try PR-M for the Default Payroll
  
• The reason why you cannt open the table is because one of the records has a data on a field that does not correspont the field's data type.
  
• It is suggested not to link a table, because of record locking issues.
  
• Use a "Pass-through Query" = "SELECT * FROM BKPRMSTR"
  

 

 
Kelloggs

I personally dont like to link tables, other people could have another opinion.
Try this:
 
1.- Create a Pass-through Query. I call it DBA
2.- Create a Module with the following function:
 
Function get_data()
Dim sqlString As String
sqlString = "SELECT * FROM BKPRMSTR"
CurrentDb.QueryDefs("DBA").SQL = sqlString
    DoCmd.SetWarnings False
        DoCmd.RunSQL "SELECT DBA.* INTO BKPRMSTR FROM DBA;"
    DoCmd.SetWarnings True
End Function
 
3.- Run the function.
 
If it is successful check for a record with an error value as data. Open DBA/Maintain Database and check/fix the record in question.
If the function is not successful. Narrow your query with the "WHERE" statement.
 
 
 
 
Kelloggs