Splitting database for fe/be rst.index error

[deanvilar]

having an error about recordset properties ... e.g.: RST.index --> OPERATION IS NOT SUPPORTED FOR THIS TYPE OF OBJECT

Set db = CurrentDb
Set RST = db.OpenRecordset("tblEmployees", dbOpenDynaset)
 
RST.Index = "Primarykey"
RST.Seek "=", Me.cboEmployee
 
If RST.strEmpName = Me.cboEmployee And RST.strEmpPassword = Me.txtPassword And RST.strAccess = "ADMIN" Then
 
    DoCmd.Close acForm, "frmLogon", acSaveNo
    DoCmd.OpenForm "ARCHIVE MENU FORM"
    Forms![ARCHIVE MENU FORM]![cmdAddUser].Enabled = True
ElseIf RST.strEmpName = Me.cboEmployee And RST.strEmpPassword = Me.txtPassword And RST.strAccess = "USER" Then
 
    DoCmd.Close acForm, "frmLogon", acSaveNo
    DoCmd.OpenForm "ARCHIVE MENU FORM"
    Forms![ARCHIVE MENU FORM]![cmdAddUser].Enabled = False
Else
    MsgBox "Password Invalid.  Please Try Again", vbOKOnly, "Invalid Entry!"
    Me.txtPassword.SetFocus
End If
RST.Close

[Seth Schrock]

What did you Dim rst as? Do you have a line that is something like

Dim rst As DAO.Recordset

[deanvilar]

no i don't, I just set RST as openrecordset ...

[deanvilar]

@Seth Schrock
I placed it .. also dim db as DAO.database, but it gives me an error for rst.index --> OPERATION IS NOT SUPPORTED FOR THIS TYPE OF OBJECT

[Seth Schrock]

Then you must not have Option Explicit set. Please read Require Variable Declaration. Then at the top of your code page you should see Option Compare Database. Right below that add Option Explicit. This will require you to declare all your variables. This will make it much easier to troubleshoot your code.

You will need to add the following code above the code that you showed us.

Dim db As DAO.Database
Dim RST As DAO.Recordset

This could solve the problem, but I'm not sure. What version of Access are you using?

[Seth Schrock]

Oops. Cross posted with you. What version of Access are you running? Here is the link to the MSDN website that tells how to use the Recordset.Index command. It is for Access 2010, but up at the top is a drop down for other versions that you can choose from to get the syntax for your version (which is probably the same, but best to make sure): Recordset.Index Property (DAO)

[deanvilar]

yes you are right I don't have Option Explicit, am using access 2003 sir...

[deanvilar]

ok let me read about this .. and try whatever i can find, thank you so much .. i really appreciate it

[deanvilar]

as I read... I have same use of rst.index ... but still it gives me an error OPERATION IS NOT SUPPORTED FOR THIS TYPE OF OBJECT ... is splitting the table can be a factor of this error?

[Seth Schrock]

Well, I'm not familiar with the Index property itself, but I have used other recordset properties before and all of my databases have split backends, so I would be surprised if that was the case. However, you could try it on the backend database and see if it works. Otherwise, I'm out of guesses as all I have to go on is the MSDN website right now.

[deanvilar]

many thanks for your support ... I wanted to changed my codes from rst.index and rst.seek .. to other types like rst.findfirst..etc .. but sadly I need to restructure all of my codes =(