I have a 2003 database that has been converted to Access 2007. All code is in this accdb and it creates and writes to a linked database which stores all the data.
I was asked if this could run on a PC with Office 2010 Standard -- no Access. So I tested using Access 2010 Runtime and, after a little bit of troubleshooting (and I consider myself very lucky...) I found that it does.
However, the issue I have is how to set up the Trusted Locations for these two accdbs so Runtime doesn't go nuts whenever the database is opened. One is in the Program Files, the other in the user's Application Data. I can manually create the Trusted Locations in the Registry, but what is the best practice on setting this up?