Password Protection For E-mailed Access Report

Aug 8, 2005

Password Protection for E-mailed Access Report
Sorry this is a bit long winded but here goes - we have a very simple Access 2002 DB of 60 – 100 client records. It’s updated weekly and a report is then sent to a distribution list. In the past it was printed and faxed. As all on the list have e-mail I set up a macro to e-mail the .mdb to an Outook Distribution List. It works wonderfully and is much easier and faster. However - a couple of weeks ago one of the users complained saying we must password protect the data. Our Exchange Server is not yet set up to use certificates and Ditital IDs so I worked out the only way I can think of to p/w protect the file. The data is exported as an RTF. Once the user is in Outlook she opens the attachment and runs a macro in Word which :-
Saves the RTF as a DOC file (uses the same name each time)
Saves the DOC file with password protection
However the user reports that often it seems to link to the previous weeks data unless she deletes the attached file and opens the TEMP internet files folder, finds the correct week and attaches that.
Can anyone think of an easier and more foolproof way of doing this – is there something in Access I have missed?
Thanks for any help or advice – Dika

View Replies


ADVERTISEMENT

Access Application W/Password Protection Help

Sep 8, 2005

I have a small tracking Access DB at work that someone put a password on. No one seems to know the password. I'm wondering if there is a file that stores the password so that I can remove it so I can access the DB.

Thanks for you help!

View 1 Replies View Related

Relink Database With Common File Dialog In Access 2007 W/Password Protection

Jan 9, 2008

All -

Just as the title describes, I can't seem to find a solution to be able to link the front-end to the back-end tables through the common file dialog when the backend is an accdb file that is password encrypted.

See the example attached. Here it should work just fine per the Article at :

http://support.microsoft.com/kb/181076

I've found it works fine without a password encrypted back-end but not with a password encrypted back-end.

Anyone have any ideas? It would be nice to use this feature in Access as well as automating the relinking.

Thanks!

View 1 Replies View Related

Password Protection Help

Apr 12, 2006

HI ALL,

I have been working on some database protection techniques and have found floors in all of them.

Basically I have to protect a database not using the application password... which has a different password for each form. This means using form passwords ect... but all of them can be hacked by using the shift key on start-up does anyone know how to get around this as im stuck and could really do with another’s perspective.

Thanks in advance.

View 2 Replies View Related

Password Protection

Oct 27, 2005

Hello guys

I was wondering if you can help?

Is it possible to password protect tables, forms and queries, how

Thanks a lot

View 4 Replies View Related

Password Protection

Apr 25, 2006

I need to know if there is any way to password protect a single query. I currently have a database and there are several users that have access to run queries but I need to have some security as others are making modifications to queries that they shouldn't be.

View 2 Replies View Related

Password Protection

Sep 29, 2005

I have a set of command buttons on a form that open up a series of reports. The problem I have is that only certain users should have access to particular reports and I want to be able to put some kind of password protection in.

If anyone knows how to do this please let me know.

Thanks

View 4 Replies View Related

Help With Password Protection For Forms

Sep 18, 2006

Hi,

I need some help creating a way for two different type of users to be redirected to different forms after entering a password.
I tried using the groups security in access but it's not good.

What I need the program to do is:

ask the user to enter a password. then if the password is correct and they are managers they will see the managers opening form ("form1") and if they are employees they will se a different opening form("form2") with less options and different reports.

thanks.

View 4 Replies View Related

Examine Acc97 DB With Password Protection

Mar 23, 2008

I have an old access 97 database that I can open with a user password, but cannot open as an administrator. I need to look at some development issues. My problem is that the vendor who wrote the database no longer exists to help me. Does anyone know how to strip off password so that I can examine this old database?

View 1 Replies View Related

Password Protection Of Individual Forms

Mar 18, 2005

I have set up a front screen which has linked buttons to other forms.
When I open up some of the forms (using the buttons) I would like them to be password protected.

I know tihs is probably really easy, but I cant get it sussed!!

Any help would be appreciated.

thank you

Mojaveboy

View 2 Replies View Related

Forms :: Unable To Set Password Protection On A Combobox

May 25, 2013

I am trying to set password protection on a combobox where there are only a few people who I want to be able to select their name to provide authorisation. I found the below code on a website and modified it slightly for my table (tbl_Approval) that contains two fields; Approver and Password. I can see how the code is supposed to work however I keep getting a syntax error (missing operator) in query expression on line: Set rs = CurrentDb.OpenRecordset(sql).

Code:
Private Sub Approved_By_Enter()
Dim pwd As String
Dim rs As Object, rstable As Object, count As Integer, counter As_ Integer
Dim sql As String, recount As Integer
sql = "SELECT * " & "FROM [tbl_Approval] " & "WHERE [Approver]= " & Me.Approved_By
Set rs = CurrentDb.OpenRecordset(sql)

[Code]...

View 3 Replies View Related

General :: Creating Password Protection On Specific Tables?

Sep 20, 2012

I would like to know if I can create a password protection on specific tables. Within my database, there are certain tables and/or reports to be view by a selective amount of personnel. Can I password protect just that view?

View 2 Replies View Related

Forms :: OnChange Event - Setting Password Protection On Tab Control

Nov 4, 2013

I have an Access 2010 form within my database in which I have a series of 8 tabs on a tab control. I am the only user who will have access to these tabs. I want to require a password in order to permit access to the tabs. The very first tab on the tab control works as a cover tab. There is no relevant information for anyone to view...only a graphic.

How to code the "on change" event of the tab control.

View 1 Replies View Related

Access Protection Of SSN

Nov 6, 2006

I am looking for a script which would be able to give protection of SSN in tables and or view on forms when entering an SSN.....


does anyone out there have a script????

ie... 123-45-6789 would show in access table or forms

as xxx-xx-6789

View 2 Replies View Related

Access Security And Protection

May 4, 2006

Hi all,

I've recently taken over a database that a collegue of mine was developing and he has disabled certain functions within the database which I can't enable. Specifically, he has disabled the ability to right click over anthing in design view so you can view the list of options available. Does anyone know how I can re-enable this feature?

Best Regards,

Aaron

View 5 Replies View Related

How To Crack Ms Access Password, I Have Set User Name And Password

Sep 12, 2006

hi pals

i have set username and password for ms access file.

unfortunately i have forget that password?

how to crack that username and passowrd?

is there any softwares available?

i can easily crack the database pasword? but how to crack username and password of ms access file.

View 1 Replies View Related

How To Collect Data Via An E-mailed Form ?

Nov 18, 2007

I have a golf society database. I would like to be able to send, via e-mail, a 'Form' to each of the members of the society so that that they could fill in the data in the form then e-mail it back to me and then import it into the database.

Has anyone got any good suggestions on how I should do this please ?

Cheers
Frank

View 3 Replies View Related

Form With One Field To Be E-mailed Upon Update

Apr 6, 2005

I am using a form for users to enter requests. Currently when a user enters a request an email is generated using the sendobject command and i send the whole table in .xls format as an attachment to my e-mail. I'd rather when a request is entered that an email is sent to me with only the newest request in the body of the email. How can I go about doing this? As always thans a bunch in advance.

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

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

How To Access Ms-Access WorkGroup Tables To Change Database Login Password

Apr 13, 2007

Hi!
This is Kishore, working on VB Project which is using MS-Access95 as backend.
Now, i want to change the Database login Password.
Could anyone guide me in this context.

Regards,
Kishore

View 4 Replies View Related

Password Access

May 12, 2005

I obtained a login and user access from someone last year, (can't remember who it was,) and being relatively new to vba in access, have been unable to adapt it for use in access 97. Please can someone help?

The logon works great in access 2000, thanks whoever created it!

thanks
Blue-wyvern

View 2 Replies View Related

Not Prompted For Password When Relinking - 'Not A Valid Password Message'

Mar 29, 2007

I have recently split my database and added a password to the back end. I am now trying to re-link the tables as I have seen in other threads, but when I do this I am not prompted for the password I just get the message 'Not a valid password'

I must obviously be doing something wrong, can anyone help?

View 4 Replies View Related

How To Set Password To Ms Access Database

Sep 10, 2006

hi pals

i am newbie to msaccess. i want to set password to msaccess database file.

how to do this?

View 1 Replies View Related

Password In Access Aplication

Nov 23, 2007

Hello all!

I need to add a password protection to my access application, and i don't know how to do it.

The scenario is the following:

I've got a main page, where the user chooses which form or report to view. I would like to add the username and password to this startup page, and then start the session. After that I should check in all the other pages that the session has been started.

How can I do it? Does the session exists in access? or should I do a table to control whether the session has been started or not?
and then check in that table in all the other forms and reports?

thanks!

View 1 Replies View Related

MS Access Password Protecting

Jan 30, 2008

HI,

I have a MS access 2003 database (in MDB format) which I use as a basic accounts system for our company (15 user). I have certain tables password protected depending on user using the old workgroup information file. This presents a problem as anyone can copy the database without linking the Information file and effectively get full admin access. I was looking to upgrade to Access 2007 but I gather that there is a different security engine and also a new file format (accdb file). I know that you can keep the same user security settings when upgrading to 2007 (while keerping the mdp file extension) but would be interested to know if I can improve security using 2007 while also being able to retain user-level access to certain tables like in access 2003? The major weakness in my system at the moment is anybody can copy the MDB file to another PC and access everyting...it seems too easy a system to crack. Do I need to completely reprogram my database using MySql on MSSql? Any advice would be appreciated?

Thanks in advance,

Shane

View 2 Replies View Related







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