Refresh the FE

[Matt]

I have been playing around with refreshing the front end of my
application (with a method that is seamless to the user) and I have
found the following code to do so (In a .bat file):

COPY \\Cfp01sd1\IA_WIS_FINANCIAL\1 Statistical Information\Financial
Dashboard App.mdb c:\Financial Dashboard App.mdb

START "MSAccess.exe" c:\Financial Dashboard App.mdb

EXIT



But, I got an error. So I tried replacing the spaces with % and got
the following error - "Can not find the file C:\FinancialApp.mdb". It
looks like it was ignoring the middle word 'Dashboard'.

Any clue what is going on here?

As always, Thanks in advance!

 

[Perry]

Replace

START "MSAccess.exe" c:\Financial Dashboard App.mdb

by
START "MSAccess.exe c:\Financial Dashboard App.mdb"

 

[Matt]

Replace


by
START "MSAccess.exe c:\Financial Dashboard App.mdb"

--
Krgrds,
Perry

System: Vista/Office Ultimate










- Show quoted text -

When I do that, it brings up the command prompt, pointed to my
desktop, with a flashing cursor and nothing else happens

 

[aaron.kempf]

you do mean this:

START MSAccess.exe "c:\Financial Dashboard App.mdb"

HOPE THAT HELPS

right

 

[Tony Toews [MVP]]

I have been playing around with refreshing the front end of my
application (with a method that is seamless to the user) and I have
found the following code to do so (In a .bat file):

COPY \\Cfp01sd1\IA_WIS_FINANCIAL\1 Statistical Information\Financial
Dashboard App.mdb c:\Financial Dashboard App.mdb

Replace with

COPY "\\Cfp01sd1\IA_WIS_FINANCIAL\1 Statistical Information\Financial
Dashboard App.mdb" "c:\Financial Dashboard App.mdb"

START "MSAccess.exe" c:\Financial Dashboard App.mdb

Replace with.

START "MSAccess.exe" "c:\Financial Dashboard App.mdb"

Alternatively consider the Auto FE Updater which will only update the
FE MDB/MDE as required.

See the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm