Hi all, I'm currently trying to construct a query in Access that references to a temporary table I'm creating and populating on the fly.
All is going well until I try to create the query. Although I'm opening the connection to the table etc Access is claiming not to recognise the table, any ideas what I need to do to get the Jet Engine to recognise the table? Am I looking along the lines of creating some form of link like the permanently connected tables I have? TIA Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.324 / Virus Database: 181 - Release Date: 14/02/2002 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php