Re: [MSAccessProfessionals] Error 3192 in Insert command

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

On Fri, Sep 2, 2022 at 11: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

 

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116266) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_