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?