Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Bank details in Access
Name: pvbjones Date: October 10, 2004 at 09:11:23 Pacific OS: XP Pro SP2 CPU/Ram: 1ghz Athlon
Comment:
I've got a MS Access database of volunteers that work for my charity on and we want to store there bank details. The database has a password to open it but a lot of people have that password so what I need is a way of having the table that contains the bank details to have a seperate password and if possible to be encrypted. Is this possible? Is it easy? and how would I do it? Or are we better off having a seperate database with its own password and encryption?
Name: rayok Date: October 10, 2004 at 12:55:49 Pacific
Reply:
It depends on your level of paranoia but a separate "thing" is more secure and doesn't have to be a database - you can password an excel file for example or pgp a word doc
Back to the access database you can do a little bit of security on a query with the [what] criteria - if you put a number in the table and [what] in the appropriate place on the query it acts like a password as unless you type in the correct number the query won't proceed
Techy n Welsh
0
Response Number 2
Name: pvbjones Date: October 10, 2004 at 14:56:41 Pacific
Reply:
Is it possible to have a command button on a form to open a specific excel or word document? this would contain the banking info but could be pssword protected/encypted.
peter
0
Response Number 3
Name: rayok Date: October 11, 2004 at 13:25:19 Pacific
Reply:
yes that's possible - easier still, with the form in design mode (and the cursor on a space in the form) click on the hyperlink icon and point it to the document
Summary: This is an Access db to track leave slips. To enter new time we have a form with a combo box, choose a name in the combo box, then a subform shows that employee's info from our timeoff table, and lets...
Summary: hi! i wanted to know how to add expressions in access. like if there is a field 'quantity' and it has numbers. what i want is that when the quantity goes less than 3 it shud generate message abt that....
Summary: I have a combo box that is automatically filled with a list of client names when the form is opened. The only probem is, the text of the combo box (what you see before you drop it down) is always bla...
0 
