On Wed, 21 Jan 2004 05:46:08 -0800, CoffeeMug <an*******@discussions.microsoft.com> wrote:
¤ Hi Ken,
¤
¤ Thanks again for the reply...
¤ I'm getting the following error:
¤
¤ Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'
¤ This error occurs when VB tries to execute the code cmd.ExecuteNonQuery
¤
¤ The database is not in use, and the query is pretty straightforward:
¤ It copies data from a linked (through ODBC) table (pwd and UID are stored) and puts it in a new table...
¤
¤ Can you help me out please?
You may want to post your code and the contents of your Access QueryDef.
Paul ~~~
pc******@ameritech.net
Microsoft MVP (Visual Basic)