My Vb 6.0 program hangs on an NT 4.0 server when trying to append a large amount of data to another table using an ACCESS 97 database. This same append query works when called in the ACCESS database itself so there is enough memory to perform this. My code is written below:
Set wrkODBC = CreateWorkspace("", "admin", "", dbUseODBC)
Set conRao = wrkODBC.OpenConnection("", , , _
'Create the new table EQXR_XREF_2
InsertSQLstring = "INSERT INTO EQXR_XREF_2 SELECT EQXR_XREF.* FROM EQXR_XREF"
NOTE: It hangs at this point. Is there another method to try or is there a VB 6.0 bug that I am not aware of?