PLEASE HELP
I have a SQL database that uses an access front end and I would like to output each individual record when a check box is ticked. I am (somewhat vaguely) aware of 2 ways of doing this:
1. to output the file using vba DoCmd.TransferText acImportDelim etc…
2. to use SQL triggers (which I have never used before)
I am initially after some advice regarding the best way of doing this. I need to output files to be generated and then copied to a network folder. Each record will need a unique (incremental numeric) file name and the file needs to be space delimited fixed length ASCII (SDF).
Please can someone give me some advice about the best way of doing this and perhaps where I can find information that might help me achieve my goal.
Many thanks
I have a SQL database that uses an access front end and I would like to output each individual record when a check box is ticked. I am (somewhat vaguely) aware of 2 ways of doing this:
1. to output the file using vba DoCmd.TransferText acImportDelim etc…
2. to use SQL triggers (which I have never used before)
I am initially after some advice regarding the best way of doing this. I need to output files to be generated and then copied to a network folder. Each record will need a unique (incremental numeric) file name and the file needs to be space delimited fixed length ASCII (SDF).
Please can someone give me some advice about the best way of doing this and perhaps where I can find information that might help me achieve my goal.
Many thanks