After splitting the DataBase I get the error - Object isn't supported

rzielins

Registered User.
Local time
Today, 23:12
Joined
May 2, 2001
Messages
13
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
 

Users who are viewing this thread

Back
Top Bottom