.bat file to deploy database from server

[Leesha]

Holy Cow, I never dreamed by question would spark such a dialog! I'm late at getting back to this due to my fried laptop making my life hell. Anyway I replace the code as suggested with
set source=\\%server%\C$\Autoload\%dbname%
however still am getting a failure message. I tried pinging the computer and its active.
Thanks!
Leesha

[John Gray]

Hmmm, fried laptop! Yummy!

I can only think the problem is that the file doesn't have the right path.
After that "set source" above try inserting
if not exist "%source%" echo Can't access "%source%"
pause

Check that the contents of %source% are what you expect.

[grovelli]

Any news about the datetime routine spot of bother and how to avoid the warning message and just silently allow the creation of the log file?

[ZaveR]

I just found where everyone went!! I missed this kind of give and take. I was going through posts, and am wondering- did anyone suggest using AUTOFEUpdater? IT is great and works in all kinds of situations. (IfI am late to the party, let me know, but I am just so glad to have found everyone again- that I had to post something)

[HansV]

Hi Zave, welcome to Eileen's Lounge! (I did send you a hint about Eileen's Lounge last year, apparently you missed it...)

For others reading this: Auto FE Updater is a great utility by Access MVP Tony Toews. It used to be free with a request for donations, but since he got hardly any donations, Tony decided to make it a commercial product about half a year ago. You can test it for free though - after downloading and installing you have a 15 day trial period.

[grovelli]

Welcome back with us Zave. The party's been ongoing since 2002... (I'm not sure what this smiley is doing with his hand)

[HansV]

(I'm not sure what this smiley is doing with his hand)

One hand raises a trophy, the other makes a thumbs-up gesture (at least, I hope it's not the middle finger... )

[ZaveR]

i thought it was a beer mug

[HansV]

i thought it was a beer mug

The beer mug features in the "cheers" smiley and also in the "thankyou" smiley

[grovelli]

at least, I hope it's not the middle finger...

Yes, it was his left hand that raised my concern a bit...

[grovelli]

By the way Hans, I was reading the Access blog this evening and there was a link to the Access forum on Microsoft Answers and I see you're there too! And you finally got the long-deserved MVP badge of honour, congratulations!!
You should put the acronym beside your name on here as well.

[HansV]

Hi Giorgio,

Thank you! If you look at my profile here on Eileen's Lounge, you'll see that my MVP status is mentioned there, but my username will remain HansV.

[Pat]

well done Hans

[HansV]

Thank you, Pat!