Link to home
Start Free TrialLog in
Avatar of AndrewMcLaughlin
AndrewMcLaughlin

asked on

Removing Design View for Table and Query Objects

I have an Access database with the back end upsized to SQL and the front end in MDE format published on the company intranet to allow read only access to the records. However users can still see the Table and Query objects in design view and edit these.

Is there anything I can do to the master database before I create the MDE files to ensure that, as for Forms and Reports, when converted to MDE format the user can not see these onjects in design view.

Thanks,

Andrew
Avatar of rockiroads
rockiroads
Flag of United States of America image

Go to Tools/Startup

then in the checkboxes, hide the checkboxes which say Allow Full Menus, Show Database Window etc

also click on advanced and uncheck the special keys

but it is possible to open the DB using the shift key but there is some simple VBA code which disables that

(make sure you backup your DB before doing this otherwise you wont yourself get back into it)
ASKER CERTIFIED SOLUTION
Avatar of rockiroads
rockiroads
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of AndrewMcLaughlin
AndrewMcLaughlin

ASKER

Fantastic -

Just one further question.

I have a button on switchboard that, via a macro, opens a table for the user to see.  However - after making the above changes- when this button is pressed the table view pops up for a split second and then reduces to an icon.  The only way the user can see it is to close the switchboard, after which there is no way to re-enter exc except closing everyhing down and starting over again.  How can I get around this?

Thanks,

Andrew
how are you opening the table?
post your code here, lets have a look
Table opens via a macro - but it opens behind the switchboard form so that the user can not see it, and I don't want to allow Min/MAx on the switchboard form itself.

Open Table
Maximize

Datasheet view
Maximize
Ok, I just tried it and I seem to be getting the full datasheet view

I was just wondering, if it returns as an icon when the security settings are made, perhaps you cannot then view the table due to the restrictions

I made a MDE but dont seem to have the problem your getting
I wonder what effect it will have if you did it through code

e.g.

DoCmd.OpenTable "EE1", acViewNormal, acReadOnly

where EE1 is my tablename, note I opened it up as readonly