problem with backend import

[TIbbs]

I split my database and it works fine, but I have a problem with my pass through queries. I have two front ends, one for usual users and an admin that is to sit in the server with timer controls.
The pass-through queries are in the admin front end, but now if I run the pass through queries, they download to the front end, and not in the back end as I thought it would.
The vb code included deleted the current table and download a new one from Sage first thing in the morning.
Which changes would I have to carry out, so that the tables will be placed on the backend instead and I can carry out several deletes and imports.

 

[neileg]

The easiest way is to create tables in the BE. Then delete and append records, not delete and create tables.

 

[TIbbs]

Thanks, I'll try this approach