By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,273 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Request suggestions for streamlining distribution process

P: n/a
I'm looking for a way to streamline the process of distributing an
access application. Right now, it's an awkward and error-prone
procedure. I'm using Access 97 and the related ODE.

I maintain two source MDBs, one with only partial content and one with
full content. Otherwise, they are identical.

Here are the steps.

1. Copy the modified MDB to a setup folder (this keeps me from
accidentally creating any problem in the development folder).

2. Find the ODE wizard in start menu.

3. Select the wizard and run it.

4. Navigate to the zip output folder, and rename or delete the
previous zip version.

(This allows me to create a new zip archive instead of opening an
existing one when I zip the distributable files).

5. Find winzip and run it.

6. In winzip, navigate to the folder which is to contain the output
zip file and specify the zip archive name.

7. Still in winzip, navigate to the folder which contains the output
of the ODE wizard (i.e., the distributable files).

8. Archive these files into winzip.

9. Find my FTP program and run it.

10. Within FTP, navigate to the folder containing the zipped file, and
upload it to my web site.

For some reason I'm always getting tripped up somewhere. There's a lot
of navigating, and the way Windows is set up (Desktop, My computer,
Drive C, Product Folders, Product folder), I'm always in at least four
or five levels for each navigation. So it adds up, and then add in
separate zip names for the full and partial versions, there's another
twist. Usually I output the full and half to different distribution
directories, so there's another thing I have to account for.

Ideally, I'd be able to batch it up and just run a macro to do all
this, with just a flag specifying which version. Any ideas at all are
welcome, though.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.