24. august 2006 - 08:37Der er
10 kommentarer og 1 løsning
Connecte til ekstern database (View)
Hej,
Jeg har fölgende kode: ----- If Not IsNull(DLookup("[No_]", "[dbo.vw_Thorn_Svenska_AB$Customer]", "[No_]=txtKundenr")) Then sSQL = "INSERT INTO Labels ([Kundenr])" & vbCrLf & _ "SELECT ([No_])" & vbCrLf & _ "FROM [dbo.vw_Thorn_Svenska_AB$Customer] WHERE [No_] = " & txtKundenr.Value Me.Requery DoCmd.RunSQL sSQL Else MsgBox "Kundenr. " & txtKundenr & " kendes ikke", vbExclamation
End If txtKundenr = "" txtKundenr.SetFocus
End Sub -----
Den henter fra en linked table (view) i Access: dbo.vw_Thorn_Svenska_AB$Customer
Den giver fölgende fejlmeddelelse: Run time error 3078 The Microsoft Jet Database engine cannot find the input table or query 'dbo.vw_Thorn_Svenska_AB$Customer'. Make sure it exists and that its name is spelled correctly.
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
Have you linked the view using a DSN (ODBC) connection? If so, can you open the view directly? Can you also make a query using the linked table? If you can then you should be able to use the view in the code above.
I´ve tried to make a simple query in Access that withdraws "no_" and "name" from the view [dbo.vw_Thorn_Svenska_AB$Customer] and it works perfect, but somehow it won´t work with the code above. It´s a ODBC connection! :-) and i can open it (doubleclick) and se all the values/customers.
Now i got another message. It seems like the connection to the view works now but i get the following halt: Data type mismatch in criteria expression.
When i do what you told me i got following: ?sSQL INSERT INTO Labels ([Kundenr]) SELECT ([No_]) FROM [dbo_vw_Thorn_Svenska_AB$Customer] WHERE [No_] = 17116516
I´ve checked that [No_] field is the same type as in table Labels (Text) and that the value is 20. Now i´m lost :-)
He he! I´ve got i working. All i needed to do was add ' & ' (where the number was, 17116516)in this line: FROM [dbo_vw_Thorn_Svenska_AB$Customer] WHERE [No_] = 17116516
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.
