Error 3192 when try insert record in sql server

[mencoxx]

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
'---------------------------------------------------------------

and 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?


a million thanks Domenico

 

[NauticalGent]

In your navigation pane, is there a table named dbo_tblSchMod or did you remove the "dbo_ " prefix when you linked it?

 

[theDBguy]

Hi. Welcome to AWF!

Are you able to create and run an Append query using the designer?

 

[cheekybuddha]

FYI - cross posted here

 

[NauticalGent]

Lol, asked in a newsgroup as well, but has yet to respond to any of the answers

 

[mencoxx]

In your navigation pane, is there a table named dbo_tblSchMod or did you remove the "dbo_ " prefix when you linked it?

I found this solution, I don't Like but work
'--------------------------------------------------------------------------------------------------
Dim rs As DAO.Recordset
Dim Sql As String

Sql = "Select Top 1 Stato, Collezione, Modello, Articolo From dbo_tblScheMod"
Set rs = CurrentDb.OpenRecordset(Sql)

rs.AddNew
rs("Stato").Value = "X"
rs("Collezione").Value = "X"
rs("Modello").Value = "X"
rs("Articolo").Value = "X"
rs.Update

rs.Close

Set rs = Nothing
'-----------------------------------------------------------------------------------------------

 

[mencoxx]

Ciao. Benvenuto in AWF!

Sei in grado di creare ed eseguire una query di accodamento utilizzando la finestra di progettazione?

Hi, I'm getting the usual error: 3192

traslate:

Could not find output table <name>. (Error 3192)​

 

[The_Doc_Man]

I found this solution, I don't Like but work
'--------------------------------------------------------------------------------------------------
Dim rs As DAO.Recordset
Dim Sql As String

Sql = "Select Top 1 Stato, Collezione, Modello, Articolo From dbo_tblScheMod"
Set rs = CurrentDb.OpenRecordset(Sql)

rs.AddNew
rs("Stato").Value = "X"
rs("Collezione").Value = "X"
rs("Modello").Value = "X"
rs("Articolo").Value = "X"
rs.Update

rs.Close

Set rs = Nothing
'-----------------------------------------------------------------------------------------------

When you see the table in the navigation pane, can you open it into datasheet view? If so, using the navigation controls, jump to the first record then jump to the last record. Does that work? If you cannot do this test, the table is corrupted. If you can do this then I don't know offhand.

 

[mencoxx]

When you see the table in the navigation pane, can you open it into datasheet view? If so, using the navigation controls, jump to the first record then jump to the last record. Does that work? If you cannot do this test, the table is corrupted. If you can do this then I don't know offhand.

can you open it into datasheet view? Yes
o the first record then jump to the last record. Does that work? yes

I know and it's really a strange problem.

Thanks a lots
Domenico