At work all of our Access databases are connected to a secure work group with different levels of password protected access (i.e. base level is read-only, top level is Database Designer).
I designed a database for a member of staff (using Access 2002) who is not from my department and who only has runtime access and they are unable to open it. When they click on the icon it has a bit of a spasm and brings up a warning box that code within the database may be unsafe (it isn't), and if they click 'open' it simply brings up a blank screen. The IT department has tried Runtime Access versions 2000, 2003 and 2007 with exactly the same results.
Is the problem the secure workgroup that I have to connect to whenever I use Access? I know I can't open any database without having to enter a password, so could this be causing the problem?
If it is, how do I stop it? Can I get Runtime Access to look for a workgroup elsewhere? If so, how? Or can I connect the database to the secure workgroup? Again, if so, how because Runtime's controls are minimal.
It's driving me insane because the database itself took days to set up and is needed for use by the other department in the next week or so and our IT department have come up blank (which isn't an entire shock).
Any help would be greatly received.