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?