MS Access Version = 2007
Hi all - I'm somewhat new to all of this, but have created a few small applications using VBA in the past few months. Far from comfortable with it, but am learning more each day (and thoroughly enjoying it).
I'm not sure if Access is the right tool for the next project I've been asked to handle and thought I'd ask you for your opinions.
The project is fairly straight forward: Zipped files, containing two MS Excel files, are recieved 4 times a day on an FTP site. We need to get the contents of those files (where each ROW in the spreadsheet would be a complete RECORD in Access) into a queue where it would be presented to one of 10 users located in the US and London. So basically, when User A clicks a button, he/she would be presented with a form containing the record details. User B should NOT get that record, but instead the next available in the queue (regardless of where he/she is working).
I assume I could do this by automating some kind of status when the record is open...but since I don't even have Access installed yet, I thought I could verify the approach here. The db would live on a central server everybody can access.
Here's what I'm not too sure about yet:
- Can there be something that polls the FTP site at some interval to see if there's a new file available?
- Can the zip file be unzipped, the spreadsheets extracted, and the data imported to the db with little or no user intervention?
- Would User B see the updated status on a record when it's changed by User A?
Sorry to be so verbose and vague at the same time... as noted, I'm just trying to figure out what the best approach would be.
Thank you for any input!
Regards
JP
Hi all - I'm somewhat new to all of this, but have created a few small applications using VBA in the past few months. Far from comfortable with it, but am learning more each day (and thoroughly enjoying it).
I'm not sure if Access is the right tool for the next project I've been asked to handle and thought I'd ask you for your opinions.
The project is fairly straight forward: Zipped files, containing two MS Excel files, are recieved 4 times a day on an FTP site. We need to get the contents of those files (where each ROW in the spreadsheet would be a complete RECORD in Access) into a queue where it would be presented to one of 10 users located in the US and London. So basically, when User A clicks a button, he/she would be presented with a form containing the record details. User B should NOT get that record, but instead the next available in the queue (regardless of where he/she is working).
I assume I could do this by automating some kind of status when the record is open...but since I don't even have Access installed yet, I thought I could verify the approach here. The db would live on a central server everybody can access.
Here's what I'm not too sure about yet:
- Can there be something that polls the FTP site at some interval to see if there's a new file available?
- Can the zip file be unzipped, the spreadsheets extracted, and the data imported to the db with little or no user intervention?
- Would User B see the updated status on a record when it's changed by User A?
Sorry to be so verbose and vague at the same time... as noted, I'm just trying to figure out what the best approach would be.
Thank you for any input!
Regards
JP
Last edited:
