Overwriting files with a VBS or BAT file.

[Matt]

I guess this is more of a windows question than an Access question,
but you guys seem to be able to answer it all, so I feel comfortable
throwing it out there!

Situation:
Currently we have a FE/BE structure, with about 10 users on my front
end. As of now, all 10 users access the same copy of the front end
over a network.

Problem:
The company outsourced its networking to a another company
(Southberry) that came in and made everything unbearably slow. Now
that our networks are on 1994 speed, opening the FE and navigating
through the screens is a chore, so you could imagine what running a
report is like.

What I want to do is have all 10 users (a number that will be
increasing very soon) each have a copy on thier PC. This will speed
up most actions (still will have to access the BE over the slow
netowork, but just have to live with some things).

What I need help on is an easy way to write a windows script to go to
the network, copy the FE that is currently out there, and paste it to
the users desktop. Taking it even further, I want this to overwrite
their current copy (if they have one), so that when I make updates and
post them to the network, I dont have to go to each persons desk to
copy and paste it for them (They are not very technologically savvy,
and I am lazy), but rather have them click this icon. I cant imagine
this is that hard, I am just unfamiliar with windows scripting.

 

[tina]

see http://www.granite.ab.ca/access/autofe.htm

hth

 

[Phillip Hagan]

One way to solve this problem is to create a shortcut that does the work for
you by compacting and copying the code from the server to the user
workstation. The target property of the shortcut should include something
like this:

"C:\Program Files\Microsoft Office\OfficeFolderName\msaccess.exe"
\\ServerName\FolderName\FileName.mdb /compact C:\FolderName\FileName.mdb

Note: You must make the correct changes to the generic target property
above to fit your specific need. It works for me.

Good luck
Phil
San Diego, CA

 

[Matt]

One way to solve this problem is to create a shortcut that does the work for
you by compacting and copying the code from the server to the user
workstation. The target property of the shortcut should include something
like this:

"C:\Program Files\Microsoft Office\OfficeFolderName\msaccess.exe"
\\ServerName\FolderName\FileName.mdb /compact C:\FolderName\FileName.mdb

Note: You must make the correct changes to the generic target property
above to fit your specific need. It works for me.

Good luck
Phil
San Diego, CA










- Show quoted text -

I am using the following

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" O:
\IA_Wis_Financial\1 Statistical Information\Financial Dashboard
App.mdb /compact C:\abc.mdb


It is telling me that I am using a command that microsoft access
cannot recognize ... am I missing something here?