Hi
I'm really, really stumpted on this problem!
I have locked my database down (prevented F11 and Shift key bypass) but if you go into My Computer, right click on the database file (test.mdb), click Properties, Opens With, Change, Microsoft Office Excel, OK, Apply.
Double click on test.mdb, Excel opens and shows all the tables that exist.
If you then double click on one of the tables, the contents open into an Excel spreadsheet.
In a nutshell, I want to prevent the ability of Excel opening any of the tables that exist within test.mdb. If not, the disabling of F11 and Shift was pointless.
Does anybody know how to achieve this?
I have spent hours searching the net, these forums and various settings within the DB itself. I tried hiding the tables within Access but they are still visable within Excel.
HELP!