Greetings,
This seems like it should be a simple problem, but I'm new to Access and my digging hasn't yielded a solution. I would like to create a table in a non-protected database that contains only certain (non-sensitive) fields selected from a table in a password-protected database. I need the fields in the new table to update automatically when changes are made to the original table. I need the unsecured table so that I can query it from MATLAB without having to hard-code the password to the secure database.
I've tried linking to the table from the non-secure database, but could not delete the sensitive fields, and hiding them does not provide the level of security I need.
I don't think a relationship between the two is appropriate, as the second table will be only a subset of the first. I also tried using a sub-datasheet, unsuccessfully.
At present I don't have administrative rights to apply user-level security, though so far this looks like it may be the only long-term solution. Is there something I'm missing? Thanks so much! (Access 2003)
6 2010
Greetings,
This seems like it should be a simple problem, but I'm new to Access and my digging hasn't yielded a solution. I would like to create a table in a non-protected database that contains only certain (non-sensitive) fields selected from a table in a password-protected database. I need the fields in the new table to update automatically when changes are made to the original table. I need the unsecured table so that I can query it from MATLAB without having to hard-code the password to the secure database.
I've tried linking to the table from the non-secure database, but could not delete the sensitive fields, and hiding them does not provide the level of security I need.
I don't think a relationship between the two is appropriate, as the second table will be only a subset of the first. I also tried using a sub-datasheet, unsuccessfully.
At present I don't have administrative rights to apply user-level security, though so far this looks like it may be the only long-term solution. Is there something I'm missing? Thanks so much! (Access 2003)
Hi.
Actually you don't need to link external table to query it. You can query external table using SELECT...FROM...IN... syntax.
Example for password protected external db query -
SELECT *
-
FROM tblTable IN 'Z:\db1.mdb'[MS Access;PWD=Password;DATABASE=Z:\db1.mdb];
-
Good luck.
Thanks for the reply, FishVal,
I did follow your advice and get the query to run, which was more than I knew how to do before. My concern with this is the same as with running the query from MATLAB, however. The password to the protected database is exposed in the un-protected database to anyone who looks at the SQL-view, so it's not an acceptable security situation. When I link to the table, on the other hand, it seems that the password is not stored in a way that can be viewed by other users. This is what I'm after. Any ideas?
Thanks for the reply, FishVal,
I did follow your advice and get the query to run, which was more than I knew how to do before. My concern with this is the same as with running the query from MATLAB, however. The password to the protected database is exposed in the un-protected database to anyone who looks at the SQL-view, so it's not an acceptable security situation. When I link to the table, on the other hand, it seems that the password is not stored in a way that can be viewed by other users. This is what I'm after. Any ideas?
Sorry Bmoore, so far it seems to me that user-level security in intermediate db is the only way.
BTW password could be more or less easily retrieved from linked table. - ? CurrentDB.TableDefs("LinkedTableName").Connect
in VBA immediate window.
Sorry Bmoore, so far it seems to me that user-level security in intermediate db is the only way.
BTW password could be more or less easily retrieved from linked table. - ? CurrentDB.TableDefs("LinkedTableName").Connect
in VBA immediate window.
Thanks - that's what I needed to know. If linking isn't necessarily a secure solution, either, then it looks like user-level security will be the best way for us to go, even if it takes some work to get there. I appreciate your help!
Thanks - that's what I needed to know. If linking isn't necessarily a secure solution, either, then it looks like user-level security will be the best way for us to go, even if it takes some work to get there. I appreciate your help!
Thanks.
I've actually meant this
At present I don't have administrative rights to apply user-level security, though so far this looks like it may be the only long-term solution. Is there something I'm missing? Thanks so much! (Access 2003)
You can apply user-level security on db containing one above mentioned query not dealing with the main db. The only disadvantage is that performance may be lower.
Okay, that sounds like a good solution - and faster to implement. I can work on getting the necessary permissions, but setting up security on the intermediate db will be a good start. Thanks...
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Larry Peeters |
last post by:
Hi,
I have created a very simple query to link two tables on 4 fields.
However, in certain cases, one of the fields used to link the table
may contain nulls (in both tables, so this should still...
|
by: Phil S |
last post by:
I used the Migration Workbench for Oracle 9.2 Client to migrate the
tables in an Access 2K back-end database to Oracle. (The Migration
Workbench is intended to automate the process of migrating...
|
by: diskoduro |
last post by:
Hi!!
Years ago I built a database to control the production of a little
factory.
The users wanted to work in a Windows Net workgroup so I created an
mdb with all the tables and data an after...
|
by: Olly |
last post by:
Find an id number not present in a linking table
I have a linking table (tblPayment) that monitors the subscriptions
from members. However, I need a query that can compare the ID number
fields...
|
by: dskillingstad |
last post by:
I've been struggling with this problem for some time and have tried
multiple solutions with no luck.
Let me start with, I'm a novice at Access and I'm not looking for
someones help to design my...
|
by: Pat Sagaser via .NET 247 |
last post by:
I'm using a repeater with a dynamic template. I don't know the fields to display (or how many) until runtime. I have everything working except for linking Button events to the repeaters ItemCommand...
|
by: ARC |
last post by:
I'm having trouble here with Access 2007 and connecting to a different
database.
The code below works great IF the previous back-end database connection is
still present and you are trying to...
|
by: occyink |
last post by:
I run a website selling cartridges. My stock on the website is in a MySql database. My accounts package and invoicing software runs on an Access database. In my website databse there is a table...
|
by: mburns |
last post by:
Hello all-
I was wondering if it is possible to link an Access query or table to a Word document and pull specific information into Word by manually entering a unique identifier, which would then...
|
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...
|
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: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
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: 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:
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...
| |