I have coppied a front end backend database into one new database file in order to show to other users on a lap top. The database will not open and give an error : type mismatch at this line.
SQLStr = "SELECT ID FROM tblStaff WHERE InUse = '" & fOSMachineName & "'"
Set RS = CurrentDb.OpenRecordset(SQLStr)
While Not RS.EOF