View Single Post
  #3 (permalink)  
Old July 11th, 2007, 04:17 AM
JezLisle JezLisle is offline
Authorized User
 
Join Date: Jun 2007
Location: , , .
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Rob, Thanks for the reply.

I am getting a little lost, basically I am trying to get the import TEMP table to append to the live db table in the back end DB (this is held on another drive), I changed the cnn in the error line to CurrentConnection, but this again says it cant find the table I want to append to. Is this because when I import the TEMP table its on my front end DB, how can I get it to import to the back end DB? then would I need to use cnn or currentconnection as both tables would be in the same DB but the code where the command button is in another DB?

Jez

Reply With Quote