My database worked fine before I split it using the MS Access DB Split Wizard.
However, now it produces the following error message in one of my forms:
"Operation is not supported for this type of object".
It occurs at a SEEK statement
StudentICASelectionstbl.Seek
StudentICASelectionstbl is a recordset I defined using the following code:
Set StudentICASelectionstbl = ICADB.OpenRecordset("tblStudentICASelections")
tblStudentICASelections is a table in my database that is now split from the Form.
Is the error being generated because the FrontEnd cannot find the backend table "tblStudentICASelections"? I would have thought that the database splitter wizard would have taken care of issues like this. If indeed this is the probelm, is there a way around it?
thanks!
Rob
However, now it produces the following error message in one of my forms:
"Operation is not supported for this type of object".
It occurs at a SEEK statement
StudentICASelectionstbl.Seek
StudentICASelectionstbl is a recordset I defined using the following code:
Set StudentICASelectionstbl = ICADB.OpenRecordset("tblStudentICASelections")
tblStudentICASelections is a table in my database that is now split from the Form.
Is the error being generated because the FrontEnd cannot find the backend table "tblStudentICASelections"? I would have thought that the database splitter wizard would have taken care of issues like this. If indeed this is the probelm, is there a way around it?
thanks!
Rob