Meyoy
New member
- Local time
- Tomorrow, 04:03
- Joined
- Nov 23, 2021
- Messages
- 3
Please help
When ever other user access this file, this error show " Run-time error '3044':
'C:\Database\BDx_be.accdb is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."
the real Front end file name is BDx_fe.accdb
when i open the debug, it highlighted the click event of the log in button;
Private Sub btnLogin_Click()
Dim rs as Recordset
Set rs = CurrentDb.OpenRecordset("LoginTbl", dbOpenSnapshot,dbReadonly)
rs= Findfirst "UserName='" & Me.TxtUserID & "'"
If rs.Nomatch=True then
Me.lblWrongID.Visible = True
Me.TxtUserID.SetFocus
Exit Sub
End IF

When ever other user access this file, this error show " Run-time error '3044':
'C:\Database\BDx_be.accdb is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."
the real Front end file name is BDx_fe.accdb
when i open the debug, it highlighted the click event of the log in button;
Private Sub btnLogin_Click()
Dim rs as Recordset
Set rs = CurrentDb.OpenRecordset("LoginTbl", dbOpenSnapshot,dbReadonly)
rs= Findfirst "UserName='" & Me.TxtUserID & "'"
If rs.Nomatch=True then
Me.lblWrongID.Visible = True
Me.TxtUserID.SetFocus
Exit Sub
End IF