Importing Data to Back End

[TKnight]

Hi,

I have a DB that relies on text file imports as well as input and I recently split it. Unfortunately now my refresh script that updates the tables based on the text files imports them into the FE rather than the BE. I have messed around with workspaces but am struggling to get a solution. Ideally i'd like to be able to call DoCmd commands directly in another database but if anyone could give me the code to execute a function I can take it from there.

Thanks, Tom

 

[TKnight]

Thanks Pat,

I tried something very similar yesterday using delete/append queries or make table queries from linked tables to update the data. Unfortunately I then hit the "Numeric Field Overflow" message that I often get in the same situation. Compacting soothes the problem but by no means eliminates it and as users will be updating the data not me I can't risk it happening.

Importing the data into the front end MDE seems like it will work becuase if the FE gets corrupted then I can just ship out a new one and the import script will replace the data from the text files. I still have all the important input data in the BE which I can backup/compact regularly.

Do you forsee any other issues in leaving it this way?

Thanks, Tom.