Microsoft喷气引擎无法找到输入表或查询'tblInManHeader'。确保它存在且该名称拼写正确 [英] The Microsoft jet engine cannot find the input table or query 'tblInManHeader'. Make sure it exists and that name is spelled correctly

问题描述

Private Sub cmdRetrieve_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdRetrieve.Click

        Dim txtSQL, tempCust, UREDI As String
        Dim Mark As String
        Dim C45, C40, C20 As Integer
        Dim lSize As Long
        C45 = 0
        C40 = 0
        C20 = 0
        txtBC11.Text = "Searching..."
        txtPosNo.Text = "Searching..."
        txtGroup.Text = ""
        System.Windows.Forms.Application.DoEvents()
        'Rs1.Open "Select * FROM tblInManHeader, tblInManDetil, tblKPBC, tblPelabuhan, tblKemasan1, tblInManContainer, tblGrup Where NoBL = '" & Trim(txtBlNo) & "' And tblInManDetil.Car = tblInManHeader.Car And tblInManHeader.KdKPBC = tblKPBC.KdKPBC And tblInManDetil.DPelMuat = tblPelabuhan.KDPort And tblInManDetil.JNKemas = tblKemasan1.KDEDI And tblInManDetil.Car = tblInManContainer.Car And tblInManDetil.KDGrup = tblInManContainer.KDGrup And tblInManDetil.NoPos = tblInManContainer.NoPos And tblInManDetil.kdgrup = tblGrup.kdgrup", AccessConnect, adOpenStatic
        'Rs1.Open "Select * FROM tblInManHeader, tblInManDetil, tblKPBC, tblPelabuhan, tblKemasan1 Where NoBL = '" & Trim(txtBlNo) & "' And tblInManDetil.Car = tblInManHeader.Car And tblInManHeader.KdKPBC = tblKPBC.KdKPBC And tblInManDetil.DPelMuat = tblPelabuhan.KDPort And tblInManDetil.JNKemas = tblKemasan1.KDEDI", AccessConnect, adOpenStatic'
        Try
            Koneksi()
            Dim sql1 As New OleDbCommand
            sql1.Connection = database
            sql1.CommandType = CommandType.Text
            sql1.CommandText = "Select * FROM tblInManHeader,tblInManDetil,tblKPBC,tblPelabuhan Where NoBL = '" & Trim(txtBlNo.Text) & "' And tblInManDetil.Car = tblInManHeader.Car And tblInManHeader.KdKPBC = tblKPBC.KdKPBC And tblInManDetil.DPelMuat = tblPelabuhan.KDPort order by tblInManDetil.nobl"
            rd1 = sql1.ExecuteReader()
            rd1.Read()

当我用同名的新数据库替换旧数据库时出现错误。数据库内部没有任何变化。它只是改变记录。



有人请帮助我。

The error just come when i replace the old database with the new one with the same name. Nothing has changed inside of database. It just change the record.

Somebody please help me.

推荐答案

我正在使用ms.access 。我已经检查过该表并且已退出。数据库版本没什么不同。就像我说的。它只是改变了记录而不是表格。

i am using ms.access. i have already checked that table and it is exits. Nothing different in version of the database. Like i said. It just changed the record not the table.

这篇关于Microsoft喷气引擎无法找到输入表或查询'tblInManHeader'。确保它存在且该名称拼写正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！