How To Protect Access Database

Feb 15, 2013

1. How to protect my access database. That is can i only let my boss to use ONLY and not see the struture / table relationship?

2. That i can use access table to call file form my computer desktop outside folder. Can i set the limit time for outside folder?(for example 3 days, after 3 days then the folder will damage or not exist? can i do that?

3. can i set the password and after some days(for example 2days). they cannot go into my access database?

4. can i make my access database only for use only, cannot copy and can i set the life time for my access database (for example maybe 2 days,
the access database cannot open. )

View Replies


ADVERTISEMENT

Protect Database Against Corruption?

May 25, 2005

I have a split database. BE located at a server and FE on each users workstation. There are 8 concurrent users at the most. This runs smoothly over the LAN.

Now I'm adding a new feature to the database. I'm using a wheel loader to weigh products on a weight scale. The operator in the wheel loader is going to use a laptop with wireless LAN to connect to the network.

In risk of loosing the connection which in worst case might corrupt the database, I want to make a new database with a BE/FE setup. The BE will be placed on the same server as the current db. The FE in the wheel loader. I can then link from the current db (BE) to the new db (BE).The new db will only require two linked tables from the current db.

If worst case happens, would my current db be more protected against corruption than if I linked directly to the BE on the current db. I know there's no 'right answer' to this one, but I'd really like some opinions on it though.

Thanks in advance.

View 5 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

Access, Protect Tables

Aug 27, 2005

How I can protect the tables in a database and force the users to access them only through 'forms'. In other words the user will not be able to view or change the data in any table except through a form, when loading a form, the protection is diabled.
I need a total solution, I am not a powerful programmer. :confused:

View 2 Replies View Related

How To Protect Access From ODBC Disconnects?

Dec 16, 2007

I finally got a chance to test the setup remotely, and it basically works with all the links I've set up.

I wanted to see how it would behaves should it disconnect or something and thus manage it gracefully.

First, I broke the network connection and tried to navigate to next record. Instead of getting a error message, Access just crashes. I'm not sure if this can even be trapped at all.

Secondly, I disconnected the connection then reconnected it. Access then tells me that the server has gone away, presuming because it's still looking to the old connection that was broken. Running the code to repair link fails also with same error. Can this be resolved with having to quit & restart Access?

Thirdly, I put a breakpoint on Form's Error Event but this doesn't seem to always to catch all errors. It does catch error if I tried to start up a form without the connection, but if it already has been started, and the connection was broken, the Error Event is never fired even though I get a dialog saying ODBC Call failed, then a zillion of dialogs saying Object no longer set or invalid. This would be extremely annoying to my end users.

Can any of those be avoided or fixed?

View 9 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

Protect Data

May 9, 2006

i have a users table where i save usernames and paswords. So anyone who has access to the users table and has little know how of access can read the passwords of other users. So I have encrypted these passwords. Now no one can read eachothes passwords but if someone has acess to the database he can copy his encrypted password to someone else's password and login using other people's account.

Any solution ????

View 1 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

Is There A Way To Protect Shortcut On Desktop ?

Dec 6, 2005

Hello,I need to know is there any way to protect a shortcut on desktop ?Bcz someone is deleting (I dont know by mistake or intentionally) shortcut of database shortcut. I thinking about its protection from deletion only unless you have to supply a password or code something like that.Any idea..?With kind regards,Ashfaque

View 1 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 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

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

Protect Tables From Import

Feb 15, 2005

is there *any* way to lock down a db so that a user can't import your tables and queries? i know an .mde prevents the importing of forms, but i don't want ANYTHING to be able to be exported. i'm thinking this may not be possible.

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

Protect Field Data From Deletion

Sep 15, 2005

I created a form for project tracking. The form has a project name field in it that is a required field. The manager fills that out first, but may go back later to fill in additional data. I created a button to allow them to search for a project name, but they keep opening the form and typing in the project name they want to search for in the project name field of the first record that appears. This changes or deletes the project name for the record they typed in. Is there a way to prevent them from typing in that one field after a project name is initially entered?

View 5 Replies View Related

Using Comboboxes To Spellcheck And Protect Bad Data?

Jun 11, 2006

I'm trying to make my database easy as possible for everyone to use while protecting against potential typos and the likes. I then had an idea and wanted to make sure if that was in line with accepted practices everywhere else. After all, just because you can do it, doesn't mean you should.

Would it be reasonable to have fields that would likely to have repeating data across various records to be a comboboxes. The fields I'm thinking of are City and ZIP code, which I would start with some more common ones, and allow users to add new ones while having the benefit of auto-expand as spell checker and reduce possiblity for bad data.

I'm not sure what ramifications that may have on forms beyond the fact that more lookup tables=slower database, especially over the network.

So would you want to make city or zip code or other similar fields combobox instead of a bound textbox?

View 4 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







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