Reuben Cummings
reuben at gfconsultants.com
Wed Jan 19 16:13:15 CST 2005
Gustav, I downloaded and installed that FTP software and your modules. They work perfectly. I have created a zip process using a class from John Colby, but it requires I install a dll on every users computer. Does the zip package you mention make installation (for me)simpler? And do you have a module to run it from within Access? I already have around 140 installs state wide and need to minimize the amount of work needed to add this Zip and FTP feature. I notice that the docs say that it does not need to be installed. I only ask because I would like to have all the info before digging too far. Thanks. Reuben Cummings GFC, LLC phone: 812.523.1017 email: reuben at gfconsultants.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock Sent: Wednesday, January 12, 2005 1:36 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Zip and send to web server Hi Reuben Not very fancy, but for similar non high-profiled tasks we use Windows Command Line FTP which adds the bonus of displaying a status window where the user can monitor the progress of the transfer which otherwise seems to "take forever": http://www.pacific.net/~ken/software/ Note the copy-n-paste module for Access to drive this. We also use Freebyte Zip for the same reasons - a progress window for the user to monitor: http://www.freebyte.com/fbzip /gustav >>> reuben at gfconsultants.com 12-01-2005 18:57:50 >>> John, how difficult would it be to just use those two pieces from your framework and fit them into my app? You asked about FTP. I don't care how it's done, FTP or email. Once the files are zipped they will usually fit into an email, but I could see that becoming an issue in the future as some db's are approaching 25 megs now. So ideally it would FTP to my web server. Zipping and FTP'ing from within the app would be perfect. You mentioned a damaged file from changes made during the zip - is that a damaged zip file or damaged mdb? Thanks. Reuben Cummings GFC, LLC phone: 812.523.1017 email: reuben at gfconsultants.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John W. Colby Sent: Wednesday, January 12, 2005 11:12 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Zip and send to web server Reuben, It sounds like you need the ZIP class as well. I have never done specifically what you are discussing, but I do hook the zip (and unzip) classes into my framework and the FTP class as well. Obviously using my framework it becomes a few lines of code to do this. It turns out you can zip a file while users are in it, though if any changes are made in the moments the zip is occurring you will get a damaged file. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Reuben Cummings Sent: Wednesday, January 12, 2005 10:59 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Zip and send to web server Sorry for re-posting, but I wanted to add one thing. Can this be done from within the app that the BE is connected to? That would be ideal as the user could then simply click a button in a given app and that BE is zipped and sent to me. Thanks. Reuben Cummings GFC, LLC phone: 812.523.1017 email: reuben at gfconsultants.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Reuben Cummings Sent: Wednesday, January 12, 2005 10:49 AM To: AccessD Subject: [AccessD] Zip and send to web server I am interested in an app that an end user could have that would zip a database and send it to my web server all in one step. The user would browse to a file, select it, and this app would zip it. And in the zip process would include the clients name and current date in the file name. Anyone have something similar? Or the pieces that I can throw together? Reuben Cummings GFC, LLC phone: 812.523.1017 email: reuben at gfconsultants.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com