Set dbadd = DBEngine.Workspaces(0).OpenDatabase("D:\odir\access\adres.mdb")
dbadd.execute "Insert into People(Fname) Values(""John"")"
Seems like it should work fine. Any clue.
Sun, 17 May 1998 03:00:00 GMT
Jouni Tiaine #2 / 2
WHAT IS THE TRICK FOR sql insert?
Try this:
dbadd.execute "Insert into People(Fname) Values('John')"
:I can not get it to work. : : :Set dbadd = :DBEngine.Workspaces(0).OpenDatabase("D:\odir\access\adres.mdb") : :dbadd.execute "Insert into People(Fname) Values(""John"")" ::Seems like it should work fine. Any clue.
WHAT IS THE TRICK FOR sql insert?