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  4634  
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.mdb"
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
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,556
Expert Mod 16PB
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
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
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
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)...
|
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?...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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...
| |
