Tables :: Password Protect A Linked Table Or Make It Read Only

Nov 14, 2012

I have a table that I imported from another database. I used import Access - Link to the table source by creating a linked table. - then downloaded in my database.

I want to use the linked table to create relationships and forms but do not want to even accidently edit it. The table gets updated in the database on a weekly bases and I am hoping it gets updated automatically in my database as well. does it automatically get updated or do i have to set up something?

Also, I want to protect the data in that particular table and either password protect it or make it read only. Can I do that? If so, how?

View Replies


ADVERTISEMENT

Password Protect A Table?

Dec 2, 2004

hi,

Is it possible to password Protect a table in Access 97?

I need to limit who can actually go into the raw data table as even though it is hidden, a user can easily unhide if they knew how.

any ideas?

View 3 Replies View Related

Tables :: Linked Table Disable Password SQL Server

Feb 4, 2015

In Access2010 I have created a linked table to a SQLServerExpress database.I have a user in SQLserverExpress with only reading rights.This linked table is used in a form which only shows the information. When opening the form, it prompts for the SQLserverExpress username and password.How can I configure the linked table so that it logs in automatically with the SQL user I prefer so that the user does not need to enter a user / password?

View 3 Replies View Related

Tables :: Make Calculated Field In One Table That Calculates Values From Another Table Linked By Order ID

May 13, 2015

I have what is probably a stupid question but I've been struggling with this one for a while. I have an ordering database which has an Orders table (containing Order ID, Date, Supplier etc) and an Order Line table within which I have a combo box for Product name, supplier, price, VAT rate, Line price etc. At the moment, I have the order line table as a subform within the Order form (run from the Orders table). The problem I'm having is the subtotal and total fields. At the moment these are in the Order Line table as I cannot figure out how to get these in the Orders table. In summary, can I make a calculated field in one table that calculates values from another table (linked by Order ID)?

View 3 Replies View Related

Make Tables Read Only

Jun 17, 2005

can anyone plz tell me how to make a table read only to prevent users from changing the records in the table?

View 2 Replies View Related

Linked Tables Across Network Are Read Only

May 22, 2006

I have a main computer where my Access Application runs but I also want other computers with the application runnign on it but linked to the backend database on the main computer, however when linking to the tables they are only read only.

How do you link to tables accross the network so you can read and writ e to them?

View 5 Replies View Related

Can I Password Protect....

Dec 7, 2006

one form in my database?

I would like to put a password on one form; all other forms are open to see.

Can this be done?

View 1 Replies View Related

Password Protect Backend

Jun 17, 2005

I have an Access 2000 split into FE and BE and the client has requested the BE be password protected. I attempt set database password on BE but then when I open FE I get error msg " not a valid password". I get the same error message if FE has same password or if FE has no password.
Any ideas?

Thanks,

Jim

View 3 Replies View Related

Password Protect VBA Code

Sep 19, 2006

Hi,

Is the password property in Access secure enough to protect VBA code?

Regards,
B

View 14 Replies View Related

Password Protect A Form?

Aug 28, 2007

Hi

i am wondering if it is possible to password protect a form?

I am building a DB which will hold personal information, all this info will be held in a table and displayed on a form, but I would like it so that the user has to enter their user name and password and only the form which relates to their details opens ( so like an open form and display specific field but passworded)

Any ideas?

View 3 Replies View Related

Password Protect A Form

Jan 25, 2005

Is there a way to password protect a form.

This is due to me having to send a mdb file, because i use A97 and the other end use A2000.

I tried sending the mde file but they could not convert it etc.

But i want to stop them getting into the code, you know how protective we are.

I want to hard code the password if thats any help.

Could some one please help me, thanks

View 4 Replies View Related

Password Protect A Button

Feb 3, 2005

Can someone point me in the right direction of how to protect a button using a password please

cheers

Andy

View 1 Replies View Related

Password Protect A Form

Feb 11, 2005

How can i simply prompt the user for a password when they click a button, if the password does not match the form will not open?

View 1 Replies View Related

Trying To Password Protect A Report.

Feb 14, 2006

As you can tell, I am trying to password protect a report.

This works great, but if you don't type anything in, all the employees names come up. How can you prevent that.

Like [Enter Employee Name Only] & "*"

Any Ideas

View 3 Replies View Related

Password Protect A Button

Feb 3, 2005

Can someone point me in the right direction of how to protect a button using a password please

cheers

Andy

View 7 Replies View Related

Linked Table's - Read Only

Apr 2, 2007

Is there a way to link MS Access tables as "read only" in Access2000?

Thanks,
SKK

View 2 Replies View Related

Password Protect Database Window??

Sep 6, 2005

Hi,

How can I hide the Database window with password protection?

For example, if someone attempts to access the Database Window, they would be promted to enter the password before they can see the tables and queries...


Thanks for your help

View 1 Replies View Related

Vba: Open Password Protect Spreadsheets

May 24, 2006

Hi all!

I have some Access 2000 VBA code which opens all of the Excel 2000 spreadsheets in turn in a particular folder. However, if one of the spreadsheets is password protected I want to ignore this file and move on to the next one...is this possible?

Any help most appreciated.

Neil

View 1 Replies View Related

Is It Possible To Password Protect Specific Macros?

Feb 20, 2007

Ive searched the forum and not found any threads relating to this. Some help would much be appreciated!

View 3 Replies View Related

Reports :: Possible To Password Protect A Report

Oct 28, 2013

i was just wondering if it was possible to password protect a report. so for example when a user clicks on the button from a switchboard a password prompt would open up and if a user entered an incorrect password the report wouldnt open up.

View 2 Replies View Related

Forms :: Password Protect A Checkbox With Particular Record

Jul 15, 2013

I have a checkbox that when checked will close that particular record from future editing. I want to be able to password protect this checkbox. Also I want to be able to uncheck this box with a password if we need to reopen that record.

View 2 Replies View Related

Put Password Protect On One Form From On Click Command From Mainform.

Nov 4, 2004

I'm new in access world. please help. I have many forms that control by On click command from the main form. One of the form (which is Calendar form), I like to have password protect in away that only the right ID or password would have access to edit this Calendar, If not users can only view it. Is this possible?, if it is can you please provide some code for me...Thanks in advance..

View 1 Replies View Related

General :: Possible To Password Protect Access To Source Code?

Jun 10, 2012

I've been working on a large project for my employer for a year now (but software development isn't part of my normal day to day duties). Most of the work (around 70%) has been done in my own time at home. The company were going to buy a system that would be customized by developers at a cost of around $60,000. I've developed a solution that is probably better than what they would have got. At my last appraisal my boss said that it had been discussed that i would be rewarded if i delivered it. My question is:

Is it possible to password protect access to the source code? I'm working with Access 2003 just now. I know I can create a .mde file to prevent access to the source code but that would make further development difficult. e.

View 8 Replies View Related

Forms :: Popup Subform - Password Protect Individual Records

Jul 23, 2014

So I created a new form that multiple coworkers will have access to. I understand that you can password protect an entire data base, but I was wondering if you could go deeper than that. I have a main form with a combo box (query to show existing IDs) for "ClientID" that links the main form and subform (Its controlsource is ClientID from the table the subform was created off of). If a user selects an existing ClientID, the linked subform pops up with the selected ClientID displayed on the subform in a field along with existing additional information displayed. If The user types in an ID not in the database, a blank subform comes up for the coworker to create this new record and the field for ClientID is blank.

1) How can I make it so that when a coworker types in a ClientID in the combobox that is not in the database, the blank subform that pops up has the ClientID field filled out with what was typed in the main form.

2) Situation: Adding a new client to the main form, and filling out the additional in on the popup subform. I want there to be a field on the main form for "worker". The worker will put their ID and create a new client record. Is it possible to make it only possible for this worker to edit this client record in the future? ...the original creator will be the only one able to edit the information.

-I am thinking maybe have a table with all workers and associated passwords. So, if a user tries to open a subform created by another worker, he will be prompted to enter a password (which will be the one associated to the creator in this "secret" table.

View 5 Replies View Related

Extracting Data From Linked Db2 Table Using Access Make Table Query

Aug 29, 2006

Hi,
I am extracting data from linked db2 table using access make table query. First I create a select query and can view the linked db2 data, but when I change to a make table query I get an error message, "invalid argument", when I run the make table query. There is no selection critera specified. Has anyone had this happen? and Do you know a solution?

Thanks for your support
GinnyP

View 1 Replies View Related

Need To Make A Change In A Linked Table

Jun 16, 2005

This question will surely show my amateur Access skills... I have to add a field to a linked table. However, the table doesn't save my changes. Is there something I need to do before I make my change?

I get the error message "Table 'name' is a linked table with some properties that can't be modified. Do you want to open it anyway?

Any ideas? Thank you! :confused:

View 1 Replies View Related







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