Solved

Removing Design View for Table and Query Objects

Posted on 2004-04-05
6
349 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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 …

737 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