Hello all,
I am wondering if anybody can help me with a question I have.
I am planning to create an Access database application, this application will be used to keep simple records and stored locally on the users computer. What I want to do is the following:
1- When the user opens the application I want only a form to open, and from this form all the other forms may be accessible.
2- I don’t want the user to be able to even see that there are tables and forms and so on, and therefore keep them from changing the design of the forms and deleting any record from the table.
Is this possible? I would really appreciate the help.
Thanks in advance,
Christina
9  4666   MMcCarthy 14,534
Recognized Expert Moderator MVP
Hello all,
I am wondering if anybody can help me with a question I have.
I am planning to create an Access database application, this application will be used to keep simple records and stored locally on the users computer. What I want to do is the following:
1- When the user opens the application I want only a form to open, and from this form all the other forms may be accessible.
2- I don’t want the user to be able to even see that there are tables and forms and so on, and therefore keep them from changing the design of the forms and deleting any record from the table.
Is this possible? I would really appreciate the help.
Thanks in advance,
Christina
Create a master backup of the mdb file as you won't be able to alter the file about to be created.
1. Create a backup copy of your "filename.m db"
2. Go to Tools - Startup and set the startup form to the switchboard/menu form you've created. Uncheck the "Display Database Window". If you have created a custom menu then change menubar to the custom menu and uncheck the "Allow Full Menus" and "Allow Toolbar/Menu Changes" boxes. Please note that if any of your users are experienced users they may find ways around this. It would require an experienced developer or some time to explain and code them out fully.
3. Go to Tools - Database Utilities - Make mde file. This will create an executable version of the file and this cannot be altered structurally by you or anyone else.
Mary
 ADezii 8,834
Recognized Expert Expert
Hello all,
I am wondering if anybody can help me with a question I have.
I am planning to create an Access database application, this application will be used to keep simple records and stored locally on the users computer. What I want to do is the following:
1- When the user opens the application I want only a form to open, and from this form all the other forms may be accessible.
2- I don’t want the user to be able to even see that there are tables and forms and so on, and therefore keep them from changing the design of the forms and deleting any record from the table.
Is this possible? I would really appreciate the help.
Thanks in advance,
Christina
1- When the user opens the application I want only a form to open, and from this form all the other forms may be accessible
Look into creating a Switchboard. This can be the central point from which all other Forms are open, and with the help of the Switchboard Wizard is very easy to create. If you need further help, let me know.
NeoPa 32,573
Recognized Expert Moderator MVP
Mary's answer gives very strong protection. If you don't need that much but just want to hide the database window and show a form automatically, look in the Tools / Startup section and there are a number of options that will enable you to do that.
As ADezii says, the usual way to do that is to start with a Switchboard form (Create one, then set that in Startup as your starting form).
Thank you all for you help.
Mary i have tried to convert my database to an MDE file but it keeps returning an error and refuses to convert. Im not sure what the problem is. Could you possibly help me with this. I have pasted the message from the error below.
This error is usually associated with compiling a large database into an MDE file. Due to the method used to compile the database, a considerable number of TableID references are created for each table. The Microsoft Jet database engine version 4.0 can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
Thanks alot.
Christina
MMcCarthy 14,534
Recognized Expert Moderator MVP
Thank you all for you help.
Mary i have tried to convert my database to an MDE file but it keeps returning an error and refuses to convert. Im not sure what the problem is. Could you possibly help me with this. I have pasted the message from the error below.
Christina
1. How many tables are there in the database?
2. What is the saved file size of the database?
3. Did you compact and repair the database recently?
Mary
Dear Mary,
im sorry for the late response.
These are the answers to the questions you asked:
1- the size of the DB is 9 MB
2- I have 15 tables
3 - I compacted and repaired the DB but i didnt see any changes in the size or anything so im not even sure it did it right.
Thanks alot for you help. I apreciate the help.
Christina
MMcCarthy 14,534
Recognized Expert Moderator MVP
Dear Mary,
im sorry for the late response.
These are the answers to the questions you asked:
1- the size of the DB is 9 MB
2- I have 15 tables
3 - I compacted and repaired the DB but i didnt see any changes in the size or anything so im not even sure it did it right.
Thanks alot for you help. I apreciate the help.
Christina
OK, size shouldn't be the problem then. Have you set up extra indexes on the tables? Another thing to try is to open the VBA editor and try to compile the database and see if this produces any errors.
Mary
Thank you Mary,
Turned out i had a code error that showed when i compiled the DB. After i corrected it i created the MDE file and it worked.
All is good :)
Thank you again very much!!
Christina
MMcCarthy 14,534
Recognized Expert Moderator MVP
Thank you Mary,
Turned out i had a code error that showed when i compiled the DB. After i corrected it i created the MDE file and it worked.
All is good :)
Thank you again very much!!
Christina
You're welcome Christina. I'm glad everything is working for you now.
Mary
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Elroyskimms |
last post by:
I have a table using an identity column as its Primary Key and two
columns (table reduced for simplicity) EmployeeNumber and ArrivalTime.
CREATE TABLE (
IDENTITY (1, 1) NOT NULL ,
(10) COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL ,
NOT NULL ,
CONSTRAINT PRIMARY KEY CLUSTERED
(
|
by: Simone |
last post by:
Hello All.
I would like some advice.
What is the best way to make an Access database design not accessible?
Like accessing tables, form design and etc.
Is it a good idea to make a MDE file? What other options do I have?
On more question should all users have their own front end?
Thanks a lot.
|
by: Wayne Aprato |
last post by:
Is there an effective method of preventing users from accidentally or
maliciously deleting the database file/files from a shared network
drive? At the moment, I'm using a batch file to copy the data.mdb to
another secure location every time a particular user who performs most
of the data entry exits the database. Setting the windows permissions
for the database folder to "read only" seems to create problems and
data entry users obviously...
|
by: Trevor Williams |
last post by:
I have a split database which has some rudimentary security in place which
prevents unauthorised users from double-clicking the data file and seeing
anything worthwhile. If they do this a popup window appears telling them
they have to use the front-end database to see the data.
The problem with this is they can still link the back end data tables into
an application they have control over and see the data that way.
Is there any way to...
|
by: Allen Anderson |
last post by:
Hi,
I'm trying to design contact (names and addresses) tables in an Access
database. Some of the contacts represent vendors, some are board members of
the organization, some are donors, some are neighbors of the organization,
some are politicians, etc. Rather than create separate tables for each type
of contact, I thought it would be better to have:
one table with names/addresses
one table with kinds of lists (vendors, board...
| | |
by: mark_aok |
last post by:
Hi all,
I have a split database. Both the forms, and the tables are stored on
a shared network drive (this is Access 2003).
The users use the forms, and the tables on the network drive, there
are no local copies.
When connection to this drive is lost, Access CRASHES. It does it
every single time. Does anyone know if there is a way to check if
|
by: thread |
last post by:
Hi All
i'm building a database in access and i want to restrict permissions.
from the access i can just limit the posiblity to unhide an hidden
table and in this way i can preventing the users from looking in un-
relevant data
my problem is how can i prevent the posiblity to import the data from
another mdb file
becaouse it is quite simple and visible to extract the information
from another mdb file
any ideas?
|
by: brendan_gallagher_2001 |
last post by:
HI
I am developog an ASP.net site (using vb.net 1.1) which will be
accessed by a number of different office locations, where certain
users will be assigned a authoriser profile, and others will be
assigned a verifier profile. At least two authoriser, and multiple
verifiers exist per office.
I need to be able to prevent two users with the same profile, and from
the same office location, accessing the same page at the same time. I
|
by: RLN |
last post by:
RE: Access 2003
Current setup is: Front end .mdb (Interface, queries, macros, etc) /Back
end .mdb (Database Tables)
I'm trying to write some code that will prevent users from getting into
the code (ie. right clicking for form design mode, F11 for the
container, etc.)
I'm testing this with two buttons on a form in a very simple app
containing one table with 3 columns, 2 rows of data and one form based
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
