Anyone Know Dos?

Anyone Know Dos?

Post by S Jackso » Sun, 25 Jan 2004 05:52:04

I am trying to create a batch file that will be on a cd with the 97 version
and the 2000 version of the database I created that I want to distribute to
a few people for testing purposes. The batch file is to go out and search
for an object library file to determine which version of office the user has
and then copy the appropriate version of my database onto their harddrive.
But for the life of me I can't figure out why this dos command won't work
(it is a test batch file)

IF EXIST c:\progra~1\micros~1\office\msacc9.olb xcopy c:\test.txt c:\test2.*

The untruncated version would be:

IF EXIST c:\program files\microsoft office\office\msacc9.olb xcopy
c:\test.txt c:\test2.*

I have tried using different paths and drilling down the three levels as I
am above and those seem to work fine. But this path does not. Why? I
broke it down and it stops working after I add the office subdirectory.

Any thoughts?

S. Jackson

Anyone Know Dos?

Post by Paul Overw » Sun, 25 Jan 2004 06:06:48

See Add-ins/Extras section of web site below. There is a white paper
concerning installing access applications. It also contains some sample VB
Scripts you may find useful.



Anyone Know Dos?

Post by S Jackso » Sun, 25 Jan 2004 06:50:21

Thanks Paul.

I checked out that program - way too complicated for what I need. I cannot
figure out how to direct it to check for different versions of MS Office.
This is so frustrating!

But, thanks for trying to help.
S. Jackson



Anyone Know Dos?

Post by S Jackso » Wed, 28 Jan 2004 00:01:13

hanks Paul. Yes it worked. It ran and told me what version I had
installed on my machine. Unfortunately, I have a very, very rudimentary
understanding of VB - I am just learning VB for Access (through trial and
error). As a result, I am not sure how to incorporate the script you gave
me into what I need on the cd - for the proper version of the db contained
on the cd to be copied onto the user's computer along with a shortcut pasted
to their desktop.

Thanks for trying to help. I think this little project is beyond me and the
users are just going to have to get their IT people to help them if they
don't even know how to copy a file from a cd onto their machine and access
it .

S. Jackson

"Paul Overway" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...