Run Time Error 3078

[jimjaix]

I am getting a run-time error '3078':
The Microsoft Jet database engine cannot find the input table or query 'ASWHELP1'. Make sure it exists and that its name is spelled correctly.

The program was working fine till I upgraded from Windows 2000 to Windows XP. I think I am missing some access data components. I have windows XP SP3 with MS Office 2003 SP3. I tried the link http://support.microsoft.com/kb/902445 but no luck. I can't modify the VB code and I tried installing Office 2000, no luck. I also have XP SP3 with Office 2003 on another computer and it works fine. I installed too many stuff on the other computer so I am not sure what I installed made it work.

 

[llkhoutx]

I answered your question on another forum.

 

[jimjaix]

I replied on the other forum, I do have the table.

 

[llkhoutx]

You state

I can't modify the VB code . . .

Have you tried repairing and compacting your program?

How are you referencing the table which cause the error message to fire?

 

[jimjaix]

I tried to repair it, it doesn't help. I went into the VB code and I found this that's related to the table.

' sql = "Delete from ASWHELP1"
' AccD.Execute sql
sql = "Select * from ASWHELP1"
Dim dynASWHELP1 As Recordset
Set dynASWHELP1 = AccD.OpenRecordset(sql)
Open App.Path & "\CONTXTID.BAS" For Input As #1

 

[llkhoutx]

Post all the code for the subject routine.

How is Accd defined?

Single step through the code and identify the line on which the error fires.