mdw with MDE

[David]

I'm about to attempt ULS again, but would appeciate some high level direction
first.

Environment: I have a FE and BE and a MDE for the user's. All user's are
using a shortcut pointed to the mde on a server. Unfortunately, I can't
figure out the auto update FE functions, but connectivity and speed is not an
issue (yet).

Up to 10 consecutive users launch MDE file from a desktop shortcut,
sharedserver1\database\database.mde

Question: Does the mdw file need to be on each desktop OR in the folder of
the MDE file?

 

[Pete]

David

There must be one mdw file in a central shared folder on your server. FE
Updater is good and worth the effort to get working.

You can also use a simple batch file, e.g. Save with a cmd file extension

@echo off
XCOPY "C:\Databases\mydatabase.mdb" "C:\Databases\" /y
"C:\Program Files\Office11\MSACCESS.EXE" /runtime
/wrkgrp"Ratabases\Security\security.mdw" "C:\Databases\mydatabase.mdb"
del "C:\Databases\mydatabase.mdb"

However this will copy itself every time and cause more network traffic.
Regards

 

[Keith]

I'm about to attempt ULS again, but would appeciate some high level
direction
first.

Environment: I have a FE and BE and a MDE for the user's. All user's are
using a shortcut pointed to the mde on a server. Unfortunately, I can't
figure out the auto update FE functions, but connectivity and speed is not
an
issue (yet).

Up to 10 consecutive users launch MDE file from a desktop shortcut,
sharedserver1\database\database.mde

Question: Does the mdw file need to be on each desktop OR in the folder
of
the MDE file?

The mdw can and should be on a network share but each user should have their
own copy of the FE mde file.

Regards,
Keith.
www.keithwilby.com