Üstad
sadece isim ve database değişikliği yaptım 3146 hatası veriyor
Sub SQLdenAl()
t1 = Time
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim sqltext As String
Dim ServerName As String: ServerName = "DESKTOP-2CF15L6"
Dim DatabaseName As String: DatabaseName = "MikroDB_V16_1"
strConnectionString = "ODBC;DRIVER=SQL Server; " & _
"SERVER=DESKTOP-2CF15L6;DATABASE=" & MikroDB_V16_1 & ";Trusted_Connection=Yes"
sqltext = "INSERT INTO CHR " & _
"SELECT * " & _
"FROM [" & strConnectionString & "].CHR " 'WHERE ([msg_S_0584]='Cari hesap') order by trim([msg_S_0134])" ' where msg_S_0584='Cari hesap'"
CurrentDb.Execute sqltext
t2 = Time
Debug.Print "Süre", DateDiff("s", t1, t2)
End Sub
Sub BaglaEkle()
Dim strConnectionString As String
Dim strNameInAccess As String
Dim strNameInSQLServer As String
' set the connection string
'Dim sqltext As String
'Dim ServerName As String: ServerName = "DESKTOP-2CF15L6"
Dim DatabaseName As String: DatabaseName = "MikroDB_V16_1"
strConnectionString = "ODBC;DRIVER=SQL Server; " & _
"SERVER=DESKTOP-2CF15L6;DATABASE=" & MikroDB_V16_1 & ";Trusted_Connection=Yes"
' specify the tables you want to link. The table can be
' known by a different name in Access than the name in SQL server
'strNameInAccessEk = "TblEkli"
'strNameInAccessBg = "TblBagli"
strNameInSQLServer = "CHR"
' delete the table from the local database if it exists
'On Error Resume Next
'DoCmd.RunSQL "drop table " & strNameInAccessEk
'DoCmd.RunSQL "drop table " & strNameInAccessBg
'On Error GoTo 0
'DoCmd.TransferDatabase acImport, "ODBC Database", _
'strConnectionString, acTable, strNameInSQLServer, strNameInAccessEk
'DoCmd.TransferDatabase acLink, "ODBC Database", _
'strConnectionString, acTable, strNameInSQLServer, strNameInAccessBg
End Sub