D
Daniel Magnus Bennét Björck
Hi!
I have a problem in an Access 97 database. I have a routine for creating
temporary worktables in a second database, which works fine in Access 2000
but is causing problems in Access 97.
The database and table are created fine, and the table is linked correctly,
but when I come to insert data into the table I get a message saying that
the table doesn't exist (using Currentdb.Execute "INSERT INTO.."). If I
however run the INSERT query manually it works fine.
Does anyone know why or have a good example of a routine for creating temp
tables in A97?
Brgds
Danny
I have a problem in an Access 97 database. I have a routine for creating
temporary worktables in a second database, which works fine in Access 2000
but is causing problems in Access 97.
The database and table are created fine, and the table is linked correctly,
but when I come to insert data into the table I get a message saying that
the table doesn't exist (using Currentdb.Execute "INSERT INTO.."). If I
however run the INSERT query manually it works fine.
Does anyone know why or have a good example of a routine for creating temp
tables in A97?
Brgds
Danny