I have an mdb I'm trying to split and make work.

While unsplit it is running fine, (at least it does what I asked and does not throw an error) and my code appears to have compiled. (I think.)
However, once split, the opening form errors out with "3219 Invalid operation". This error ONLY comes up when I enter with the shift key. The opening form just sits there and does nothing when I launch without the shift key.

It bombs out on the line below with " Error # 3219,invalid operation"
"Set rec = db.OpenRecordset("tblAuthUsers", dbOpenTable) "


The code in the button to open the db once the person is confirmed to have a password and permissions is:

Dim db As DAO.Database
Dim rec As DAO.Recordset
Dim strUserPasswordInput As String ' hold password user gives to
Dim varFoundUserPW As Variant ' store
Dim strUserInitInput As String ' store user initials,
Dim strUserPWStored As String
Dim strUserInitStored As String
Dim intUserLevelStored As Integer

Set db = CurrentDb

Set rec = db.OpenRecordset("tblAuthUsers", dbOpenTable) '
rec.Index = "AuthID" ' set up to use seek,


I used the Link Tables Manager and it REPORTED back successful linkage.

Do I need to "hard code" the complete address (of where the table now resides on the BE as part of the argument for setting rec = dbopenrecordset? Is there something else not correct?

Thanks,
Loralee

Someone far more advanced than I will probably say that this is rubbish, but I have come across this problem too (in an Access2000 project - I have not seen it in 2003, yet). I solved it by not using dbOpenTable, rather I used dbOpenDynaset and used the .Find family (FindFirst, FindNext, etc)to search the recordset. You would also not need to worry about defining indices either. You certainly do not need to put the full path into the table name.

I don't really know why, but it worked, and that's all that mattered.

Alan,
Thanks!

I changed the offending line to openDynaset as you suggested, (and changed to .findfirst) and it works. We're split, compacted and for the first time we get a decent (1-2 second) load time!
Loralee