Jumat, 02 September 2022

Re: [MSAccessProfessionals] Error 3192 in Insert command

What happens when you paste the SQL into a new, blank query? Consider adding ", dbFailOnError" to the Execute. 

I assume the fields are all text. 

If the table is on SQL server, I would probably perform this append with a pass-through query. 

Duane

Sent from my mobile

On Sep 2, 2022, at 10:40 AM, domcoz <domcoz@gmail.com> wrote:


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
 

Tidak ada komentar:

Posting Komentar