We help IT Professionals succeed at work.

Removing Design View for Table and Query Objects

AndrewMcLaughlin
on
396 Views
Last Modified: 2011-09-20
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
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2006

Commented:
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)
CERTIFIED EXPERT
Top Expert 2006
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
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
CERTIFIED EXPERT
Top Expert 2006

Commented:
how are you opening the table?
post your code here, lets have a look

Author

Commented:
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
CERTIFIED EXPERT
Top Expert 2006

Commented:
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


Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.