|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Trusted location or publisher on removable driveHi 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 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\" -- Show quoteHide quoteGina 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" <samDOTdavis@pedcDOTcomDOTau> wrote in message news:OpG9u8IoJHA.4372@TK2MSFTNGP02.phx.gbl... > 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,
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 Show quoteHide quote "Gina Whipp" <NotInteres***@InViruses.com> wrote in message news:OFJUGcfoJHA.6060@TK2MSFTNGP05.phx.gbl... > 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" <samDOTdavis@pedcDOTcomDOTau> wrote in message > news:OpG9u8IoJHA.4372@TK2MSFTNGP02.phx.gbl... >> 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 >> > > 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! -- Show quoteHide quoteGina 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" <samDOTdavis@pedcDOTcomDOTau> wrote in message news:eFW8qOgoJHA.504@TK2MSFTNGP06.phx.gbl... > 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" <NotInteres***@InViruses.com> wrote in message > news:OFJUGcfoJHA.6060@TK2MSFTNGP05.phx.gbl... >> 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" <samDOTdavis@pedcDOTcomDOTau> wrote in message >> news:OpG9u8IoJHA.4372@TK2MSFTNGP02.phx.gbl... >>> 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 >>> >> >> > > 
Other interesting topics
Split Database not allowing more than one user
MDE application cracking issues cannot access shared folder on mapped network drive menu options for users Permission Denied message how to join the workgroup security file system? Concurrent Users Need to protect data input open a form Security Warning in Access 2007 |
|||||||||||||||||||||||
