473,320 Members | 1,953 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

finalizing ideas

hello. i want to first say that i welcome anyone's ideas for this post.
please feel free to throw your 2 cents in.

i have a db that i'm finishing that i'm going to be giving to others to use.
the ONLY thing they're going to need to manipulate in this db are 3 forms and
1 simple table (1 field which is a list of names). what is the best way to
secure or lock these items, as well as the other 6 or so tables, queries and
reports that i don't want them to open, change or delete. also, what
'finishing' changes should be made to polish the forms for presentation?
this can be for the items or access as a whole.

i don't know if you need to know this but there is some vba that opens and
closes various forms and reports when they're using any of the 3 forms. i,
of course, still need this to happen.

i'm looking for suggestions ranging from adjusting the whole item (query,
form, whatever) to adjusting properties on an object in the item that need to
be set. just please keep in mind that i'm not proficient with access as a
whole or vba almost at all so please be very specific in your answers.

think of this as a 'best practices' post so i really do welcome any
suggestion, no matter how small it seems.

Thank you very much in advance for your advice.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200511/1
Nov 16 '05 #1
3 1591
It's generally best to design a database with a "switchboard" form which
takes users to the places you want them to go, which should always be forms
and reports, never raw tables.
Then you can use Tools - Startup to hide the database window.

That should be enough to keep well-intentioned users on the right track. If
you have users who are mischievious or worse, you may need to take further
measures.

HTH
"ka******@comcast.net via AccessMonster.com" <u15580@uwe> wrote in message
news:5773d8fe46190@uwe...
hello. i want to first say that i welcome anyone's ideas for this post.
please feel free to throw your 2 cents in.

i have a db that i'm finishing that i'm going to be giving to others to use. the ONLY thing they're going to need to manipulate in this db are 3 forms and 1 simple table (1 field which is a list of names). what is the best way to secure or lock these items, as well as the other 6 or so tables, queries and reports that i don't want them to open, change or delete. also, what
'finishing' changes should be made to polish the forms for presentation?
this can be for the items or access as a whole.

i don't know if you need to know this but there is some vba that opens and
closes various forms and reports when they're using any of the 3 forms. i, of course, still need this to happen.

i'm looking for suggestions ranging from adjusting the whole item (query,
form, whatever) to adjusting properties on an object in the item that need to be set. just please keep in mind that i'm not proficient with access as a
whole or vba almost at all so please be very specific in your answers.

think of this as a 'best practices' post so i really do welcome any
suggestion, no matter how small it seems.

Thank you very much in advance for your advice.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200511/1

Nov 17 '05 #2
In addition, consider making the database an MDE. In this format the
forms, modules, reports, etc., can't be changed, even by you. If you
anticipate needing to change forms in the future you will probably want
to save a copy of the mdb and import the tables from the MDE when
needing to make changes.

Marc

MacDermott wrote:
It's generally best to design a database with a "switchboard" form which
takes users to the places you want them to go, which should always be forms
and reports, never raw tables.
Then you can use Tools - Startup to hide the database window.

That should be enough to keep well-intentioned users on the right track. If
you have users who are mischievious or worse, you may need to take further
measures.

HTH
"ka******@comcast.net via AccessMonster.com" <u15580@uwe> wrote in message
news:5773d8fe46190@uwe...
hello. i want to first say that i welcome anyone's ideas for this post.
please feel free to throw your 2 cents in.

i have a db that i'm finishing that i'm going to be giving to others to


use.
the ONLY thing they're going to need to manipulate in this db are 3 forms


and
1 simple table (1 field which is a list of names). what is the best way


to
secure or lock these items, as well as the other 6 or so tables, queries


and
reports that i don't want them to open, change or delete. also, what
'finishing' changes should be made to polish the forms for presentation?
this can be for the items or access as a whole.

i don't know if you need to know this but there is some vba that opens and
closes various forms and reports when they're using any of the 3 forms.


i,
of course, still need this to happen.

i'm looking for suggestions ranging from adjusting the whole item (query,
form, whatever) to adjusting properties on an object in the item that need


to
be set. just please keep in mind that i'm not proficient with access as a
whole or vba almost at all so please be very specific in your answers.

think of this as a 'best practices' post so i really do welcome any
suggestion, no matter how small it seems.

Thank you very much in advance for your advice.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200511/1


Nov 17 '05 #3
"Marc DVer" wrote
In addition, consider making the database an MDE. In this format the
forms, modules, reports, etc., can't be changed, even by you. If you
anticipate needing to change forms in the future you will probably want to
save a copy of the mdb and import the tables from the MDE when needing to
make changes.


No, you really would not want to import tables from the MDE, you would want
to separate the application into front-end (queries, forms, reports, macros,
modules, and perhaps a few local lookup tables) and back-end (tables,
relationships, and data) with the tables in the back-end linked from the
front-end. That way, you make changes on a development copy of the
front-end, and don't move it to the users for production until it has been
thoroughly tested.

Larry Linson
Microsoft Access MVP
Nov 18 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Slash | last post by:
Hello everyone I'm looking for seminar topics (and project ideas too) for my final year in Computer Engineering. I'm considering doing something on C++/Linux, considering that I love it so much...
3
by: Charulatha Kalluri | last post by:
Hello folks, I'm on the lookout for project ideas for a C++ class. The project should: -Be a "fairly complex" application
35
by: MuZZy | last post by:
Hi All, I got a issue here and hope someone can help me: Let's consider this code: // =================== CODE START ================================= using System; using System.Data; ...
12
by: Anthony Greene | last post by:
Hello, I know this isn't really a python centric question, but I'm seeking help from my fellow python programmers. I've been learning python for the past year and a half, and I still haven't...
10
by: Wildemar Wildenburger | last post by:
Hi there :) I don't know how else to call what I'm currently implementing: An object that behaves like a list but doesn't store it's own items but rather pulls them from a larger list (if they...
0
by: bcannon | last post by:
At Guido's suggestion, a new mailing list has been created named Python-Ideas (http://mail.python.org/mailman/listinfo/python-ideas). This list is meant as a place for speculative, pie-in-the-sky...
224
by: Jon Slaughter | last post by:
Sorry for all the cross posting but I'm interesting in getting a serious discussion about how usenet has become lately. Many people are moving away from usenet because of all the spam and cooks...
0
by: mistersexy | last post by:
I have been programming in python for some time but I have become short of ideas. A software exhibition is coming up, and I plan to show python's worth 'cos it is quite underrated in this part of...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.