I have a few tables with sensitive user information (passwords, etc.)
and I would like to prevent someone from opening a blank database and
importing those tables.
Is there a way to "hide" or protect these tables from being linked or
imported?
TIA 7 5099
On Aug 28, 3:36 pm, "cefran...@yaho o.com" <cefran...@yaho o.comwrote:
I have a few tables with sensitive user information (passwords, etc.)
and I would like to prevent someone from opening a blank database and
importing those tables.
Is there a way to "hide" or protect these tables from being linked or
imported?
TIA
you could put a password on the database. that way any one trying to
link to it, or import from would be prompted for the database password
On Aug 28, 10:36 am, "cefran...@yaho o.com" <cefran...@yaho o.com>
wrote:
I have a few tables with sensitive user information (passwords, etc.)
and I would like to prevent someone from opening a blank database and
importing those tables.
Is there a way to "hide" or protect these tables from being linked or
imported?
TIA
1st you shouldnt let user have direct access to your tables EVER.
2nd dont even let you users see the structure of your tables. Hide
the DB window and use code to disable the ability to use the F1 bypass
key.
3rd Set passwords to mask password.
4th if the PWs are all that sensative you shoudl never store them
anywhere. Put the password entered through some sort of 'encryption'
algorhythm and store/compare the encrypted values only.
On Aug 28, 10:08 am, DavidB <je...@yahoo.co mwrote:
On Aug 28, 10:36 am, "cefran...@yaho o.com" <cefran...@yaho o.com>
wrote:
I have a few tables with sensitive user information (passwords, etc.)
and I would like to prevent someone from opening a blank database and
importing those tables.
Is there a way to "hide" or protect these tables from being linked or
imported?
TIA
1st you shouldnt let user have direct access to your tables EVER.
2nd dont even let you users see the structure of your tables. Hide
the DB window and use code to disable the ability to use the F1 bypass
key.
3rd Set passwords to mask password.
4th if the PWs are all that sensative you shoudl never store them
anywhere. Put the password entered through some sort of 'encryption'
algorhythm and store/compare the encrypted values only.
1st - The question never implies direct access, EVER
2nd - The question never addressed the DB window.
3rd - What???
4th - The question is NOT about passwords.
5th - Reading IS fundamental, so read the question and think about
what it is asking.
So what you are saying is...
You can't prevent tables from being imported?
On Aug 28, 9:58 am, kaisersose1995 <kaisersose1... @hotmail.comwro te:
On Aug 28, 3:36 pm, "cefran...@yaho o.com" <cefran...@yaho o.comwrote:
I have a few tables with sensitive user information (passwords, etc.)
and I would like to prevent someone from opening a blank database and
importing those tables.
Is there a way to "hide" or protect these tables from being linked or
imported?
TIA
you could put a password on the database. that way any one trying to
link to it, or import from would be prompted for the database password
Thanks,
I was wondering if there was a way to protect it without a db
password.
My application starts normally without the use of a password.
I have developed some features that will "show" certain functions
depending on the user and machine name.
This of course could be stored in a table, or in code. If I do it in
code, it becomes a code version nightmare.
If, for a given project, the info is stored in a table, I could update
the data (back end on a split database) with new users as needed,
instead of recoding/compiling/deploying, etc.(Yuk!)
However, with this data in a table, someone may be able to import or
link to it and modify the user/machine permissions for the db app
features.
Thanks for reading! ce*******@yahoo .com wrote:
On Aug 28, 10:08 am, DavidB <je...@yahoo.co mwrote:
[snip]
So what you are saying is...
You can't prevent tables from being imported?
Only with User Level Security and that is still breakable if the "breaker"
knows how to use Google and is willing to spend a few dollars. This is
analogous to asking about the most secure lock for a screen door. No matter
what you do, it is still a screen door.
So...it all comes down to your requirements and expectations. If you are
just trying to make it more difficult for (mostly) honest people then there
is a lot you can do (User Level Security being the best). If you really
need robust security then you should not store your data in an MDB file.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
As Rick Bandt said, if you need strong security use a SQL database and not
MDB. If you only need to store a few tables, accessible to a few users with
a need to know; move them to a 2nd backend file and used Windows file
security to allow access. Access will not have a problem unless a user
attempts to access the linked tables. Also these tables will not have
referral integrity with the 1st backend, so your forms will have to maintain
that.
<ce*******@yaho o.comwrote in message
news:11******** *************@y 42g2000hsy.goog legroups.com...
I have a few tables with sensitive user information (passwords, etc.)
and I would like to prevent someone from opening a blank database and
importing those tables.
Is there a way to "hide" or protect these tables from being linked or
imported?
TIA
On 28 Aug, 18:24, "cefran...@yaho o.com" <cefran...@yaho o.comwrote:
On Aug 28, 9:58 am, kaisersose1995 <kaisersose1... @hotmail.comwro te:
On Aug 28, 3:36 pm, "cefran...@yaho o.com" <cefran...@yaho o.comwrote:
I have a few tables with sensitive user information (passwords, etc.)
and I would like to prevent someone from opening a blank database and
importing those tables.
Is there a way to "hide" or protect these tables from being linked or
imported?
TIA
you could put a password on the database. that way any one trying to
link to it, or import from would be prompted for the database password
Thanks,
I was wondering if there was a way to protect it without a db
password.
My application starts normally without the use of a password.
I have developed some features that will "show" certain functions
depending on the user and machine name.
This of course could be stored in a table, or in code. If I do it in
code, it becomes a code version nightmare.
If, for a given project, the info is stored in a table, I could update
the data (back end on a split database) with new users as needed,
instead of recoding/compiling/deploying, etc.(Yuk!)
However, with this data in a table, someone may be able to import or
link to it and modify the user/machine permissions for the db app
features.
Thanks for reading!
You can hide a table by right clicking on it and selecting properties.
This stops anyone from viewing it as an importable option when linking
etc. The downside is that it also disappears from query views etc
within the original database too. You can re-view it (and subsequently
re-use the table) by clicking options --view --hidden objects. I
think it is possible to hide/unhide tables using code if used in
queries etc. If i think of anything else i'll let you know This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Ray Z |
last post by:
hi, there
I build a Class Library, I write a class A to implement interface IA. The
problem is when I give the dll file to others, thet can get all information
about not only IA, but also A. They can even see my protected members of
class A. How could I hide these informations about class A, just give them
the interface informations.
thanks.
|
by: Gavin |
last post by:
How do I, in VB get the names of all the tables in an Access data bas
Also, how do I programatically get all the field names in a specific table
Much appreciated.
|
by: Back 9 |
last post by:
Hello,
In this news group I knew that Reflector for .NETis so cool.
But on the other hand I want to hide my code from it.
Is there any way to do that?
TIA
|
by: Bayazee |
last post by:
hi
can we hide a python code ?
if i want to write a commercial software can i hide my source code from
users access ?
we can conver it to pyc but this file can decompiled ... so ...!!
do you have any idea about this ...?
---------------------------------------
First Iranian Open Source Community : www.python.ir
|
by: Robert Bravery |
last post by:
HI all,
Can someone show me or point me to a place where I can find out how to
update dbase(dbf) tables.
Thanks
RObert
| |
by: =?Utf-8?B?am9uaWdy?= |
last post by:
I wrote a simple VB.NET application that imports and edits CSV files.
Now I’d like to “lock” the raw (pre-import) CSV files so these cannot be
opened separately. It is not high-sensitive data, I just don’t want folks to
peek in the files.
So time-consuming encryption is not necessary, just a simple
password-to-open that I can program in my application so it internally opens
the imported CSV file would be perfect, but I can’t...
|
by: banging |
last post by:
Hi there,
I have a question regarding locking of tables so that when two or more people try to write or update the mysql tables, it locks up. Basically I only want one person to write to the file, but many are able to read the files (or tables entities).
I am not sure if I need to lock the tables in my Java code or do I lock the tables within the MySQL syntax. I'm just a little confused on the matter.
This java code is a working...
|
by: nzkks |
last post by:
Hi I am using these: ASP.Net 2.0 with VB.Net, Visual Studio 2005, SQL Server 2005
I suspect, there is something missing in BLL class.
I created the ASP.Net form also and checked whether it is working or not. When I submit after entering the data, an error comes.
Please help me to solve this problem. Thanks
|
by: mulamootil |
last post by:
Hi - I have created multiple tables and forms for a database. We are entering data into the tables using forms which in turn are linked to items on a switchboard. I would like multiple users in different departments to have access and enter data using the forms. The items on the switchboards are created for different departments and I would like to password protect each of these items so that it is accessible by respective depts. I am not...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look !
Part I. Meaning of...
|
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: 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 projectplanning, coding, testing, and deploymentwithout 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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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.
| |