Access WorkGroup problem: Access couldn't find file - Access

[coolsmm]

Access database that has all the data in a backend database and the forms are in another database with a link to the backend. A workgroup file exists on the network with all the users setup. Created a shortcut for the front end database, and use the parameter of \wrkgrp to use the workgroup on the network. When clicking on the shortcut, then exit out and going back into the database with the shortcut, the following error message is displayed: Microsoft Access couldn't find file XXXX. The file is required for startup. The XXXX would be the name of the workgroup. If I wait a minute or so, then able to go into the database using the shortcut. Has anyone seen this before?

 

[easyit]

Hi,

you could try a slightly different setup:
use a shortcut to a batchfile. this batchfile copies the front end to the local harddrive, and starts the DB.

Create two public accesable folders on the network. One for the mdw file and another for your published front end (an mde?).

next create an empty textfile with a number in the name like : "FCM_UR_VERSIE_3B.txt"
als create a batchfile (textfile with the .bat as extensionwith the following:

echo off

c:
cd\
if not exist C:\FCM\ mkdir C:\FCM\

cd FCM

rem copy DB front end to C if there is a new version
if not exist "FCM_UR_VERSIE_3B.txt" copy "N:\CCC Facturering consumentenmarkt\rap_publ\80_urenregistratie\FCM_urenregistratie.mde" "c:\FCM\FCM_urenregistratie.mde"

rem copy versionfile if nesscesary
if not exist "FCM_UR_VERSIE_3B.txt" copy "N:\CCC Facturering consumentenmarkt\rap_publ\80_urenregistratie\FCM_UR_VERSIE_3B.txt" "c:\FCM\FCM_UR_VERSIE_3B.txt"

rem copy DB front end to C if it is not there yet
if not exist "C:\FCM\FCM_urenregistratie.mde" copy "N:\CCC Facturering consumentenmarkt\rap_publ\80_urenregistratie\FCM_urenregistratie.mde" "C:\FCM\FCM_urenregistratie.mde"

rem start thee DB using the proper parameters
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\FCM\FCM_urenregistratie.mde" /WRKGRP "N:\CCC Facturering consumentenmarkt\RAP_PUBL\88_mdw\SYS_FCM.MDW"

exit

-distribute shortcuts to the batch file for your users.
-each time it is started it will check if there is a newer version available of uor Frontend.
-If you have a new FE You simply change the name of the versionfile and make sure that the same (new) name is in the BAT file

this way the front end is NOT shared, only the backend, Thsi makes the app probably faster as wel..

MAKE SURE YOUR ENDUSER HAVE THE SHORTCUT TO START THE DB! if not carefull, they will copy the BAT file. Then they will never have a new version availabel ofcourse!
easyit