Solved

Removing Design View for Table and Query Objects

Posted on 2004-04-05
6
308 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
0
Comment
Question by:AndrewMcLaughlin
  • 4
  • 2
6 Comments
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
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)
0
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
Comment Utility
Oh, and another thing

if on your forms and reports, look in the form/report properties
there is a Shortcut Menu property, by default it is usally Yes, select No, that will mean right click is disabled and so they cannot go into Design mode
0
 

Author Comment

by:AndrewMcLaughlin
Comment Utility
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
0
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
how are you opening the table?
post your code here, lets have a look
0
 

Author Comment

by:AndrewMcLaughlin
Comment Utility
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
0
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
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


0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now