Add Security To A Table If Table Is Created After Initial Security Is Set Up

Oct 26, 2011

Is it possible to do this through vba. If security is setup for all the tables and a user goes in and creates a new table, can that table have security applied to it using code?

So maybe the creator of the table has read/write privileges but everyone else only has read only.

View Replies


ADVERTISEMENT

Modules & VBA :: Locked Database - Login Security With Created Form

Jun 18, 2013

I am looking to lock my database until the user puts in the correct credentials.

I have already put the form on Pop Up and Modal. They can still select the "X" in the top right of the window.

View 1 Replies View Related

Table Security

Feb 13, 2006

I am working in Access 2000. There is a table in the database that is maintained by two employees. All other employees should only be able to view and query the table. Is there a way to do that without having them log into Access?

View 5 Replies View Related

Table Security

Sep 15, 2005

Is there a way for people to be locked out of a table but still access the table through forms. I tried using the user security but i couldn't access the tables through the forms. So they can't change the table. But can add and modify through forms.

View 3 Replies View Related

Advice For Security & Question On Built In Access Security

Mar 26, 2007

I've read and gone though quite a few of the scrips and examples for creating logins and security and i'm getting to the stage when i need to have good understanding of the different methods.

Some of the examples whilst create a user login do not really allow for security within the database whilst the build in security wizard would appear to offer that functionality.

I am thinking that I will use the Workgroup file and that method. My question is am i able to utilise the fact that if a person 'AdamA' logs onto the database which is built into the workgroup security file. am I then able to take 'AdamA' to populate a table which records actions by a user? (I can't seem to find any thread or book reference to doing this)

View 4 Replies View Related

Splitting A Table For Security

Jun 19, 2006

I'm on a project to build a database for the stores in our area. Things like managers, banks, and partners obviously should be in seperate tables. Most of the information though, seems to belong directly in a table of stores. Basically each record is a store and there will be very many attributes per record (about 30+). Some attributes only relate to certain departments and only someone from that department should see that info. If I broke up the big table into smaller tables it would be the same information but every table would have to have the store number to link it all back together. From a design standpoint this is bad because the store number is redundant.

So my question is, is it a good idea to split up the table for security purposes?

My main concern is security, I can take a hit on performance or storage.

View 1 Replies View Related

Pivot Table Datasource Security

Nov 24, 2005

Hi,

Not sure what section this should go in but it vaguley relates to access and VBA so it's in here.

After a complete nightmare trying to do some decent graphs in ASP i decided to try using excel linked to my Access DB.

I've set up my pivot tables in Excel to link to the Db on the webserver. The user can open the workbook from the website and view the reports and graphs.

The problem is the database contains sensitive data for more than one organisation.

I have a workbook for each organisation selected dynamically when the user logs in to the webpage.

I've set a parameters in the pivot table querys so that all querys will be filtered using the users organisation code.

Trouble is you can access the data source of the pivot table through the wizard and ammend the parameter to view other organisations data.

Is there a way of preventing the user from accessing this feature i.e locking the wizard?


Thanks

TS

View 1 Replies View Related

Social Security In Table And Reports

Apr 11, 2014

How I can generate just the last 4 digits of the SSN need to be shown on the reports which are generated? For example if a SSN were: 123-45-6789 I would want the field to read ***-**-6789. I also would like to have actual row in table password protected on its own is this possible?

View 2 Replies View Related

Adding Security To A Field In Linked Table

Jun 4, 2007

Can someone tell me how to go about adding security to a field in a linked table so that only certain people can access and modify the information? I am using Access 2002. I also wonder if someone can tell me how to modify a field in a linked table? I have tried altering and saving the changes, but it won't save them because it's a linked table. Thank you in advance to anybody who can help me out here!

View 2 Replies View Related

Security - Multiple Users Accessing Part Of A Table

Nov 24, 2006

Hi,

I'm building a DB where I have multiple users. I would like to have all data in 1 table but only give access to records created by the individual user. Is this possible?

Alternatively, if each user has it's own table, how can I report on the sum of all tables.:confused:

Cheers,

Rene

View 5 Replies View Related

Security - Allow Query Building, But Not Table Building/modification

Sep 23, 2006

I've been trying to figure this out, but it looks like a no go.

I wanted to give my users the ability to create/modify queries, but NOT create/modify tables.

Does anyone know if this is possible in Access 2002?

Thanks,

Earl

View 2 Replies View Related

Changing The Name Of The Created Table In A Make-Table Query

Sep 23, 2007

Dear Access Expert

I wanted to know if it is possible to change the name of the Table which is going to be created using a Make-Table Query via code (VBA).

For example if my Make-Table query currently creates a table with the name "Table1" I want to change it to name "Table2" and then change it Back to "Table1" or "Table3" etc.... depending on the users selection.

View 6 Replies View Related

General :: Can Create Extra Sub Table Under Sub Table Already Created

Jul 19, 2012

I have two tables. The first one is as follows:

MP No (Primary key), Sales, Date Entry, Specs, Email

The second Table is as follows:

MP No, Quantity, Description, DWG, Price

There is a "one-to-many" relationship between the two tables through the MP No field so whenever I go to the first table there is a sub-table for each MP No. Correct?can I create an extra sub table under the sub table already created?

View 10 Replies View Related

Table Created By Files

Feb 23, 2007

I'm using access2003 and i want to organize a large amount of files in my company. There are thousands of files and I'm breaking the files up based on the dates. I want to create a table that automatically looks in each folder and links the job file with the job folder. This way I can create a custom query so a user just types in the job name and it will display what folder it is in. Can anyone out there help? Thanks

View 3 Replies View Related

Created Linking Table

Mar 12, 2013

I have a database with the following tables (among others):

tbl_Projects
tbl_Staff
tbl_ProjectsStaff
tbl_Payroll
tbl_Training
tbl_Clients

tbl_ProjectClients
tbl_ClientContracts
tbl_CostEstimates

As you can see I created two linking tables (project/staff and project/client).After that I linked other tables to the liking table. For example, tbl_Payroll and tbl_Training are linked to the tbl_ProjectStaff primary key.

I don't know much about access so I wanted to check if this is a correct design. I create forms that work well, but I noticed that the linking table doesn't have any data in it. The payroll table and the training table have the staff iDs and Project IDs but the tbl_ProjectStaff is empty.

View 14 Replies View Related

Is It Possible To Make A Table Replicable Thats Already Been Created

Jan 11, 2007

I have tables in a database that are not ticked replicable at present (tick button is greyed out), this is causing
the records in the table to become scrambled when we attemp to replicate the database.

Any advice please, with over 50 tables in the database we don't feel inclined to start from scratch.

Any help appreciated.

Matthew

View 7 Replies View Related

How To Add Fields To A Table After A Form Has Been Created.

Feb 24, 2006

Anybody able to help me with this. I think there should be a simple solution to it, but it eludes me at the moment. Basically, I have created a form in MsAccess with alot of vb script on it, but
now I realise that I have to add more fields to the source table.
If I insert a new unbound text box onto the form, how do i bind it to
the new field in the source table. is there a formula that I should
use? When I look at the dropdown in the control source property, it
only gives me the fields that were in existense at the time the form
was created?

your help appreciated

thanks

View 3 Replies View Related

Linked Table Being Deleted And Created Locally??

Oct 6, 2005

I have just split my multi-user DB into Front end and back end. All appears fine apart from there is code in the autoexec module that checks to see if a particular table has been updated today. Basically the first person to login to the DB each day will run this procedure without realising. Now I have FE & BE however, because the query used by the autoexec module is a "Make table" query rather than delete all data and use an append query, every person logging in is running the update each day if it is the first time they have logged in on their PC and they are getting a local table on each of their computers. Is there any code that will create the table in the networked location (when the first person of the day logs in), rather than me having to change all my "delete table" queries to cleardown data and then re-append updated data?

There are quite a lot of delete queries in my DB and I am now worried that I shouldn't have split the DB as I may have caused myself loads of work which I don't have time to do.

I have looked on other threads but cannot find the answer and would greatly appreciate some help

View 11 Replies View Related

Can You Add The Date/time To A Newly Created Table?

Mar 9, 2007

Is it possible to have the Date/Time appear as part of the name of a table? I don't want to create and rename a table I want to run a Query that will create a Table that will have the name + date or just the date.

Example

"Todays file 20070308 11:10:34 AM"

or
"2007080308"

Or
"2007080308 11:10:34"

View 3 Replies View Related

Tables :: Merge Spreadsheet Into Already Created Table

Jul 10, 2013

I've been having problems merging a spreadsheet with data into an already created table..

The main things in common is the "MC", "First Name", "Last Name".

I'm trying to update dates etc that are on the spreadsheet exported from another database, and update my datebase with those new dates..

View 14 Replies View Related

Setting A Filter On Dynamically Created Table?

Apr 23, 2015

I am currently working on a Database to automatize some process.

The User can import a CSV (Text) File via a DialogBox, which gets imported into a Table. After this, the content has to be filtered, setting conditions on 4 different rows. The new Table gets exported into a new CSV (It has to be CSV, since it later gets imported into SAP)

How can I set a Filter on a dynamically created Table (using VBA)?

Best case would be to save the filter into my Import spec, but Access doesn't seem to have this option (?)

View 3 Replies View Related

Automatically Hide Any Tables Created In The Database Except One Table

Dec 4, 2006

I want to automatically hide all the tables in the database, and automatically hide any new tables that are created, imported thereafter, except one mastertable.
How do i achieve this?

View 4 Replies View Related

Automatically Adding New Records In 5 Other Tables When ID Is Created In Main Table

Jan 13, 2008

Okay I had an idea and I thought I might get ffedback as I am relatively new to this. I went through a period a couple of years ago when I used access alot and was becoming familiar with VBA etc but I havent touched it in 2 years so Im pretty rusty.

I am running a study and need to have to create a database that:

a. collects data about participants
b. Has a number of questionnaires (5), each of which can be filled out by participants.

THe main table has a number of fields that collects info about the participants the most important of which will be the ParticipantID - an automatically generated number which is my primary key.

In table 2/form 2 I will host questionnaire one. This will be linked to Table 1/Form 1 (Particpant Information) by this tables primary key - also the Participant ID. The relationship will be 1:1. Each participant can only have one Participant ID and will only need to fill out questionnaire one once.

Is it possible that when I add a new participant to the Participant Information table/form I also automatically create a record in Table 2/Form 2 (Questionnaire 1), as well as Table 3/Form3 (Questionnaire 2) and so on so that they have the same ParticipantID...?

I was reading a similar query somewhere else and they said to use the Form_AfterInsert Event command? Is this right (see here http://www.pcreview.co.uk/forums/thread-1687644.php)?

I feel a bit stupid but I am willing to learn and try new things Once I get started I think I will be okay. If you could steer me in the right direction it would be much appreciated.

View 12 Replies View Related

Fields In Table Created With Relationship / Lookup Data Type

Jul 17, 2014

I created a table in MS Access using a Lookup & Relationship data-type. This means that my record cells call upon a particular table for values. It creates a LIST of values for that cell.When I query a particular value in this table I get every possible combination of the value. My query and code are below:

OR,

SELECT MainT.Content.Value, MainT.Source, MainT.[Entities Impacted].Value, MainT.Update,
MainT.[Divisions Impacted].Value, MainT.Announced, MainT.Effective, MainT.Stakeholders.Value,
MainT.[Ref#ID], MainT.[Issuing Agencies].Value
FROM MainT
WHERE (((MainT.Content.Value) Like "*" & [Forms]![SearchF]![ContentCB] & "*" Or (MainT.Content.Value) Is Null)

[Code] .....

This means that if I query STATES: "California", I'll get back every possible combination that exists with the name California in that particular field.The issue with this is that I'll get MULTIPLE primary key values rather than just 1. So, if one record, under STATES has California in it, but the other fields in that record have the Lookup & Relationship data-type, then every possible combination of that record will query instead of the multiple field-values form that you'll see in the table I am querying.

notice that my primary key (REF#ID) is repeated numerous times! This obviously causes problems with generating records and forms concerning information for 1 particular primary key. Is there a way around this problem other than specifying search criteria down as much as possible?! Perhaps there is some SQL code.

View 1 Replies View Related

Help Me About SECURITY???

Jul 1, 2005

:confused: I can't access my database. I used many tools to scan my database password, and I had many results but I can't used any one.
This's my database. Can you help me?

View 1 Replies View Related

Security

Aug 28, 2005

Hi

I am experimenting in creating security of a database, and elements within.

I started by creating a user account with a password. I then made a few mistakes, so wanted to delete the mdb, and start again.

However, when I now try to create a new database, or even open a pre existing database, I am asked for the user and password created in the now-deleted mdb.

Apart from the fact that it shouldn't ask for the user name and pasword created in the first database, I am sure it doesn't accept the password I intered in creating the account.

The easy solution would be to delete the file where Access stores user accounts. Where is it, and is it protected, such that I can't delete it? And even if the user name and password still exists somewhere, it should only apply to the database in which it was created, shouldn't it?

Thanks
Robert

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved