Error 3192 when try insert record in sql server

Viewed 52

I have a strange problem: I do an insert into command using as usual example:

Dim dbs As DAO.Database
Dim sql As String

Set dbs = CurrentDb
sql = "INSERT INTO dbo_tblScheMod (Stato, Collezione, Modello, Articolo) VALUES ('x','x','x','x');"

dbs.Execute sql

I get error:

Could not find output table dbo_tblScheMod.(Error 3192)

The table dbo_tblScheMod exists and visible in the Access environment in the Tables section.

Do you have any ideas?

0 Answers
Related