Hello everyone,
Is it possible to force Access to only allow the Reports and Queries sections of the interface, I don't want to allow people to view/edit tables or create forms etc.
Boss woman wants to be able to create queries and reports but I don't want to give her access to the tables.
Is this possible?
Thanks.
8  1345 
Hello everyone,
Is it possible to force Access to only allow the Reports and Queries sections of the interface, I don't want to allow people to view/edit tables or create forms etc.
Boss woman wants to be able to create queries and reports but I don't want to give her access to the tables.
Is this possible?
Thanks.
You can probably do what you are requesting by designing a Custom Interface that will display only Reports and Queries, while keeping the true Database Window Hidden and not allowing it to be displayed. I have the base code for something similar to this. If you are 'truly' interested, I'll take the time and attempt to modify it to suit your needs. If you are really interested and do not require an immediate solution, I'll be more than happy to attempt this for you. Let me know one way or the other.
That would be good, although this is my project and I don't have any budget, so wouldn't be able to give you anything but gratitude for your time.
Would users be able to create their own new queries and reports?
Ta.
Matt
That would be good, although this is my project and I don't have any budget, so wouldn't be able to give you anything but gratitude for your time.
Would users be able to create their own new queries and reports?
Ta.
Matt
so wouldn't be able to give you anything but gratitude for your time.
Wouldn't expect anything else.
Would users be able to create their own new queries and reports?
Yes NOTE: As soon as I get some free time, I'll see what I can do. We'll handle it step by step.
Just checking in, I should have something for you by Monday. I simply have not had the time to write the code, but as soon as I do, I'll let you know.
I found your request to be a little unusual, but interesting nonetheless. The following steps were taken in order to initiate this process: - The Standard Access Interface (DB Window) has been replaced with a Custom Form (frmNewDBWindow). This Form provides the same functionality as the Database Window (Open, Design, New) but only has Tabs for Queries and Reports.
- The SHIFT ByPass has been disabled disallowing the User to access the Database in this manner.
- All Startup Options have been deselected (OFF), so the User cannot open the database Window via the F11 Key, Full Menus are not allowed, Shortcut Menus are not allowed, Built-in Toolbars have been disabled, etc. All this is designed to not allow the User to access the Standard Database Window.
- I allowed backdoor access via a SHIFT+CTRL+F4 Key combination (AutoKeys Macro). This unique Key Sequence will open the Startup Properties Dialog Box where you can select all Options turning them ON again. You will then have to exit the Database, and then open it again to get back to Normal operation. Remember to turn these Options OFF again when finished.
- All code has been encapsulated within frmNewDBWindow, so simply Open the Test Database, then Tools ==> Startup ==> Deselect all Options. Exit the Database so they can take effect the next time you open it.
No that is a very handy thing. It sure beats taking a pair of pliers and pulling out the F11 key like a rotten tooth, which I've wanted to do a few times!
Well done.
Jim
That is absolutly perfect.
Thankyou soooo much - it's perfect.
That is absolutly perfect.
Thankyou soooo much - it's perfect.
Glad you enjoyed it, have fun.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Paul Keating |
last post by:
I have a very simple COM server written in Python that is trying to
return a two-dimensional array 268 x 20. The values it contains are
some small integers, some short (<29 character) Unicode...
|
by: Radioactive Man |
last post by:
anyone know of a function like "raw_input", which collects a string
from the user entry, but one where I can set a time limit, as follows:
time_limit = 10 # seconds
user_answer =...
|
by: bdotson |
last post by:
Does anyone know the record limit for a single table in Access 97? I
have a client who has over 800,000 records in one table. They are
experiencing math problems and timeouts when running reports....
|
by: Sharon |
last post by:
I'm using TcpClient and getting the Stream by:
TcpClient tcpclnt = new TcpClient();
. . .
Stream stm = tcpclnt.GetStream();
Now, when I'm trying to send a big buffer via stm.Write(...) I get an...
|
by: Bruce |
last post by:
I thought that I had read somewhere before about a limit to the number of
DLL's that could be loaded by a 32 bit application when it is run on Windows
98/ME operating systems.
But I can't seem...
|
by: David Smithz |
last post by:
Hi there,
Just run a query that has a column that has a result of more then 1024
characters( quite a lot more actually) when I display full text in
phpMyAdmin, it only seems to show up to 1024...
|
by: Mark |
last post by:
Thanks in Advance.
I encountered the 4 MB limit recently while using the export feature of
Crystal Reports version 9 Report Application Server which uses a MS SQL
Server 2000 as a data source. ...
|
by: YellowFin Announcements |
last post by:
Introduction
Usability and relevance have been identified as the major factors
preventing mass adoption of
Business Intelligence applications. What we have today are traditional
BI tools that...
|
by: Donald Adams |
last post by:
I'm creating Word 2007 reports in asp.net 1.1 via xml transform.
I get data from the SQL server in .5 sec., first transform takes less than a
sec. and uses 10MB.
I have 900MB free memory of the...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
