Question about Auto FE Update Utility

[boblarson]

I'm definitely NOT an expert when it comes to Access security and the using of the shortcuts with the MDW file.

You might try posting a brand new thread on this one to see if someone can help - using something like this subject:

Syntax for Batch file workgroup string

 

[Meltdown]

SammyLou,

Did you ever figure out how to restart the database using the workgroup file?

I'm now in the same position, the updating works great (thanks Bob!), but as it's a secured database I need to restart it through a shortcut

Melt

 

[boblarson]

Not sure if they did get it going. I THINK they did, but it was via a different thread. You might check out this alternative method as it is supposed to be able to handle the shortcut problem:

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

 

[Meltdown]

I just wanted to update this post with my solution to opening a secured access database through a shorcut using Bob's updater.

This is what you need to do:

1. Copy your shortcut string into notepad, then save it as a .bat or .cmd file, I've called mine 'open.bat'.

2. Save open.bat into C:\WINDOWS\system32 on each users PC that needs to be updated

3. Open the basFEUpdate module in Access and comment out the following line:
'Print #1, "START /I " & """MSAccess.exe"" " & strRestart

Replace with:
Print #1, "START open.bat"

4. You can also comment out:
'strRestart = """" & strKillFile & """"

That's it.

If there is a prettier solution I'd still like to hear it.

Thanks again Bob for the updater.

Regards
Melt