Thread: Access Help
View Single Post

Old 01-31-2008, 12:27 PM   #3 (permalink)
mwittman mwittman is offline
RDC:RE Guy

mwittman's Avatar

Join Date: Sep 2007
Posts: 160
Rep Power: 2 mwittman is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- NetCommunity (BBNC)

Andrea's idea sounds pretty good.

I'll throw in another approach that may work for your requirements:

For all the read-only users, you could replace the shortcut to the Access application itself with a shortcut to a command script that copies the "master" .mdb file to a local copy, then opens the local copy to the user.

I sometimes use this technique for .NET Windows applications hosted on a network share since you can't run those things directly from the share (due to a security restriction imposed by the .NET framework).

Here's a Windows command script example:


FILE NAME: MyAccessApp.cmd

SCRIPT:
----------------------------------------------
REM "S:\" would be mapped to the share hosting the master Access database application

REM Copy master file from network share to client local hard drive
xcopy /y /s /i "S:\MyAccessApp.mdb" "%APPDATA%\SteelersRule\MyAccessApp\"

REM Open local copy of application
"%APPDATA%\SteelersRule\MyAccessApp\MyAccessApp.mdb"
----------------------------------------------


I feel your pain on this issue - I've dealt with it and still deal with it


Micah
__________________
Micah Wittman

WORK

Database Coordinator
Red Deer College
blackbus4.m.wittman@xoxy.net

PERSONAL

http://bebepool.com
http://hmatters.com
Reply With Quote