Solved

Removing Design View for Table and Query Objects

Posted on 2004-04-05
6
352 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 10756076
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
ID: 10756141
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
ID: 10756617
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 65

Expert Comment

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

Author Comment

by:AndrewMcLaughlin
ID: 10756830
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
ID: 10757698
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

688 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