Hi,
I usually work with DAO, but since I know SQL is faster, so I start using it. Why does this code works for me, but not to my colleague?
I try to collect all username that connect to my database, so "On Load" event of the form, it will add their username to the linked table.
Is anything wrong with the code?
Thank you.
I usually work with DAO, but since I know SQL is faster, so I start using it. Why does this code works for me, but not to my colleague?
Code:
CurrentDb.Execute "INSERT INTO tblConnect (user_id) VALUES ('" & NetworkUserName & "');", dbFailOnError
I try to collect all username that connect to my database, so "On Load" event of the form, it will add their username to the linked table.
Is anything wrong with the code?
Thank you.