Trusted location or publisher on removable drive

[Sam Davis]

Hi and thanks for reading....

I'm working on an Access application for a school to write student reports.
It will be a multi-user app running on their LAN, however the school wishes
each teacher to be able to take home a copy of the database on a flash
drive.

My intention is to write the application in Access 2007 but as an Access
2000 compatible MDE. Clearly many teachers will not have Access installed at
home and I'd like these teachers to use the 2007 Runitme. I'm concerned
about how "Trust Locations" can be dealt with when the MDE is on a flash
drive. Has anyone done anything similar or have any ideas/tips?

Thanks, Sam

 

[Gina Whipp]

Sam,

Is each database 'self-contained'? No back-end to link to? Because I'm
curious how you are planing to have them link to the front end from the zip
drive...

That being said, I have not tried this but you could 'reset' the Registry
Key as part of your install routine...
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted
Locations\

Location(x)
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\MyDatabaseFolder\"


--
Gina Whipp


"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Sam Davis]

Gina,

On the school's LAN will be a BE on a server with copies of the FE for each
user.

Teachers will be able to create "take home" databases using a command within
the FE. This will essentially copy a "take home" template to their local USB
flash drive and then populate the template tables with their classes from
the BE. The "take home" DB will be a single Access file including code and
data. I presume many teachers will not have Access installed at home, hence
will need to install and use the Access 2007 Runtime.

Since my original post I've been testing AccFree.exe from
http://orlando.mvps.org/AccessFreeMore.asp - incredibly this seems to solve
my problem completely without the need to fiddle with the registry at all.
To my mind, this little app appears to circumvent the whole point of trusted
locations and publishers (as does the ability to run a .reg file in the
background to make any location trusted). I'm surprised, but pleased, that
the solution is so simple!

Sam

 

[Gina Whipp]

Sam,

I am glad you found a solution because I was wondering where /how you were
going to install the runtime given the circumstances. I mean I just
couldn't picture trying to install a runtime on thumb drives!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm