Much as it pains me to say it, I've been tasked with putting some security on a verrrrrrrrrrrry old Access 97 database that our users cobbled together about a decade ago. There are some basic user accounts and such, but it seems that no matter what security level someone has, if they hold down [Shift] while opening the database they are able to see all the tables, queries, code etc, and make changes there if they want to. As you can imagine, this has not gone down well with the auditors.

My main question is: is there a way of overriding this [Shift] behaviour?

Incidentally, they seem fairly amenable to moving the back-end data to SQL Server. However, I'm a little concerned that this will cause problems with the barrel-loads of macros and VBA code that update various tables. An upgrade to, say, Access 2003 seems more feasible but I don't know whether that would be of any help. It's been a long, long time since I used Access (in fact, back when Access 97 was new!) so this has come as a bit of a shock to the system.

Any advice would be appreciated...