can't read from temp table which was created from VBA backend

[haresh]

i am createing Table directly from backed with help of text file (SELECT INTO command) (Create from back end) - following points

1.Command is - strSQL = "SELECT * INTO [Testing].[" & TblName & "] FROM [Text;HDR=NO;DATABASE=" & FileFullPath & "].[" & filename & "]"
2.Command for dumping data in to table - cn.Execute strSQL

3. Create Table successfully and also showing data on My PC but same process is run from other User then i got error msg "The Microsoft Jet database engine can not find the Input table or Query 'table name'".
4. while viewing in to Table I can see table is present and also showing data which same as text file.
3. if i am using vba coding and executed one by one then allowed me to do further process from other user.. how i can do with going coding .. as other user doesn’t idea about backed

4. I am using share drive for getting out put and have full rights on MDB files which same as both user
please suggest how to resolve above issue

 

[tehNellie]

I'd suspect that the table is being created in the front end rather than the back.

Some more detail around the construction of the cn object would be helpful though.

 

[haresh]

Please find below code is using for dump text file into table .

Dim NOTISCn As New ADODB.Connection
Dim NotisRs As New ADODB.Recordset
Dim Tradefiledate As String

NOTISCn.ConnectionString = "Provider=" & Provider & ";Data Source= " & Mdbfilepathname & ""
NOTISCn.Open
NotisFile = "NotisTrades.txt"
strSQL = "SELECT * INTO [Testing].[" & TblName & "] FROM [Text;HDR=NO;DATABASE=" & FileFullPath & "].[" & filename & "]"
NOTISCn.Execute strSQL

you can try ....