security workgroup sometimes not recognised

[mackyrm]

Set-up
-------
I have an Access 2003 database - front end and backend.
front end sits on dept desktops
back end sits on an accessible network with security file/workgroup

Problem:
---------
Sometimes the network goes down and subsequently the front end on colleagues desktops can no longer access the workgroup when the network goes back up to working status. The workgroup link needs to be re-assigned from individual front ends again to the workgroup, taking up my valuable time!

Is there any VBA there can be implemented to re-link the front-end to the backend workgroup, that can be accessed from a button on a splashscreen I have set up on the database loading screen. The objective is, when the network goes down and defaults my front-end to a standard workgroup file, my colleagues can press a button on the splash screen to re-link, without me having to run over to individual collegues offices with CDs and apologies!

 

[KenHigg]

You can designate what work group to use via the shortcut command line. Do you need and example?

 

[mackyrm]

Yes please!

 

[KenHigg]

Create a shortcut and in the 'Target' put something like:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /wrkgrp "N:\myFolderName\MySecurityFile.mdw" "N:\myOtherFolderName\MyDataBase.mdb"

 

[mackyrm]

Oh! see! Just a standard shortcut pointing to both openable front end and security file. I have this working now - thank you!

 

[KenHigg]

Glad to help -