Run Time Error '3044' (1 Viewer)

Meyoy

New member
Local time
Tomorrow, 04:42
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
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:42
Joined
May 7, 2009
Messages
19,169
its:

rs.Findfirst "UserName='" & Me.TxtUserID & "'"
 

Meyoy

New member
Local time
Tomorrow, 04:42
Joined
Nov 23, 2021
Messages
3
Thank you. arnelgp.


but the highlighted code is the Set rs= CurrentDb.OpenRecordset("LoginTbl",dbOpenSnapshot,dbReadOnly)

Those it affect when you split the database? i think the LoginTbl is the error because it was save in the backend file?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:42
Joined
May 7, 2009
Messages
19,169
Relink all your FE tables.
 

Users who are viewing this thread

Top Bottom