Worktables in Access 97

[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

 

[Douglas J. Steele]

See whether what Tony Toews has at
http://www.granite.ab.ca/access/temptables.htm helps.