SQL Insert issue? (1 Viewer)

[calvinle]

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?

 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.

 

[Minty]

What error code is the failure generating? Can the other user write to that table.

 

[Ranman256]

What do you mean 'does not work'?
It throws an error?
It puts nothing in the table?

 

[calvinle]

When I open it and I check in the tblConnect backend, it shows my network user. When someone else open it, it doesnt show their user network id.

There is no error appearing. It looks like it added, but nothing. So I did a test to msgbox to see their username On Open, the msgbox prompt their network user.

But it doesnt add to the table.

 

[JHB]

Is user_id a number field type or a text field type, (then you're applying a text to it)?

VALUES ('" & NetworkUserName & "')

 

[calvinle]

Is user_id a number field type or a text field type, (then you're applying a text to it)?

The NetworkUsername is a string.

 

[JHB]

The NetworkUsername is a string.

I asked if user_id is a number field type or a text field type!

 

[calvinle]

Oh aha, text. I think I got why its not working. The user does not have writing access to the backend where the tblConnect is stored. Thats why it cannot write to the table.