G
Guest
Not sure whether this questions should go in this topic or design......
I am creating an application to distribute to employees at a number of
remote locations. There is a server at each of these locations so I was
planning to split up the app into FE and BE. On a weekly basis I would like
to "collect" the data from the BE's and consolidate on my local server.
I assume linking tables is out due to poor performance over a WAN.
Some other thoughts I had were -
1. Running a scheduled VBScript task to copy the files to my local server
2. Running a scheduled VBScript task to run a query to email the table
contents to me
Any suggestions ?
I haven't though a lot about the details yet, just want to make sure that I
have the concept right first.
TIA
IK
I am creating an application to distribute to employees at a number of
remote locations. There is a server at each of these locations so I was
planning to split up the app into FE and BE. On a weekly basis I would like
to "collect" the data from the BE's and consolidate on my local server.
I assume linking tables is out due to poor performance over a WAN.
Some other thoughts I had were -
1. Running a scheduled VBScript task to copy the files to my local server
2. Running a scheduled VBScript task to run a query to email the table
contents to me
Any suggestions ?
I haven't though a lot about the details yet, just want to make sure that I
have the concept right first.
TIA
IK