Security Newsgroups: Access Security

Re: Show/Hide controls depeding on User's wrkgrp Group

TC - 26 Nov 2005 11:37 PM - 2 messages

Brendan Reynolds wrote: Why iterate? You can test it directly, without having to loop. Also, that code will fail with a runtime error if the specified user does not exist. This version returns True if the specified user exists AND the ...

Show/Hide controls depeding on User's wrkgrp Group

Walter via AccessMonster.com - 26 Nov 2005 11:25 AM - 3 messages

Hello How do i determine what wrkgrp Group the User belongs to during a Form's OnOpen event? Walter ...

I don't have insert rights in my .mdb

dennist685 - 26 Nov 2005 5:19 AM - 3 messages

I don't have insert rights in my .mdb When I configure an access datasource in asp.net 2.0 using nwind, I can generate select, edit, delete and insert rights. When I use my own .mdb I can configure all but my insert rights. ...

Protecting/Securing IP

CCampbell - 26 Nov 2005 2:34 AM - 2 messages

I have a friend who asked me an interesting question. He has developed an MS Access database for his club, with about 2000 entries in it. Other clubs are interested in seeing it. He is afraid they will just copy it over. Is there a ...

Password hash

Brian - 26 Nov 2005 12:52 AM - 4 messages

How does one hash passwords to when using a table for user names/passwords instead of built-in Access security? This is, of course, to hide them from anyone clever enough to simply link to the Users table. ...

"unknown publisher" error in MDE

Jesper Fjølner - 25 Nov 2005 1:35 PM - 4 messages

I have sent an MDE in a zip file to someone (I'm finding out what access version he's using, but I think XP). He unzips and runs it and he gets the "unknown publisher" error. He hits "run" and gets another error saying: ...

how to set up labels one address per label on avery 5160 labels

Gary - 25 Nov 2005 1:11 PM - 3 messages

how to set up avery 5160 labels for one address per label ...

HOW TO HIDE & PROTECT BOTH A PARTICUALR CELL/ROW IN A SHEET

joshirishi - 25 Nov 2005 9:10 AM - 2 messages

I wanted to hide & protect a particular cel or row/column in a sheet ...

Urgent problem about "permissions".

Frank Martin - 23 Nov 2005 11:07 PM - 4 messages

I have Access2003 I was trying to get rid of that annoying popup when Access is opened, and now the system is asking me about "permissions" and I am locked out of the database. I am the only user and there is only this one machine. ...

With and Without (not Pink Floyd)

Dave - 23 Nov 2005 9:22 PM - 3 messages

Hello, I have an Access 2000 database running on WinXP that uses two shortcuts to open the database. One shortcut is for the administrator that uses the MDW file and prompts for the useid and password. The other shortcut is for ...

Logon Form

naiveprogrammer - 23 Nov 2005 5:04 PM - 8 messages

I have a DB that will have around 25 different users. My first question is should I create 25 different front ends or just one? I'm not sure if how it would affect the DB if that many people had the DB open at the same time? ...

Restore Tools Menu

Mary - 23 Nov 2005 3:16 PM - 6 messages

I made the mistake of altering the built-in Tools menu, and can't seem to get it back to it's default. I've tried holding the shift key, it doesn't show the complete list. I need the Database Utilities to repair and compact and to ...

Encrpyting Microsoft Access databases

mnorri - 23 Nov 2005 11:32 AM - 7 messages

I have a client that wishes to encrypt their Access databases. They want to use the PGP product, but will this cause any problems with access to the database? At present their databases are used by mulitple people on a shared ...

Max # Of Simultaneous Users

Bob - 22 Nov 2005 6:42 PM - 3 messages

What is the maximum # of users who can access a shared MDB file simultaneously? The table they will be reading from is shared. The browse screen they will be accessing the table thru is read-only. ...

ç”µè„‘ç—…æ¯’ç ”ç©¶

é˜¿è¶Š - 22 Nov 2005 11:12 AM - 2 messages

æœ¬äººè‡´åŠ›äºŽç”µè„‘ç—…æ¯’ç ”ç©¶ï¼ŒçŽ°åœ¨ä¸ºæ”¶é›†ç—…æ¯’æ ·å“ï¼Œå‘å„ä½æœ‹å‹æ±‚åŠ©ã€‚è¯·æ„¿æ„æä¾›ç—…æ¯’çš„æœ‹å‹æŠŠç—…æ¯’ä¼ åˆ°æˆ‘çš„è…¾è®¯QQå·ç æˆ–å‘åˆ°æˆ‘çš„E_Mailã€‚ ...

newbie wans to create usernames & passwords on inherited .mdb

fishy - 21 Nov 2005 11:09 PM - 3 messages

I have inherited a database that has an .mdb on its central server, however, the developer has left and I need to set up loads of new users with usernames and passwords. After that I need to set a .mde? as the team that will be ...

Visible tables become hidden; how to access them?

Gordon Jones - 21 Nov 2005 10:05 PM - 9 messages

This string began in the "Programming" section under the name "Help find lost taables!". One of my users suddenly couldn't open her application, and sent me her app_be.mdb file. I discovered that about 1/2 of her tables were not listed ...

Approval Question

Kurt Bennett - 21 Nov 2005 6:34 PM - 3 messages

Hi All, I have a access 2003 database that is comprised of different forms to do different functions. Some of the forms need a field that is tied to a digital signature to validate that a particular person approved the data in the form. ...

Error 3197 - MS Jet d/b engine stopped because you and another use

Andy Gibson - 21 Nov 2005 11:58 AM - 4 messages

The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. (Error 3197) I have been creating a database over the last few days (At home and work) ...

Concurrent Access Security Problem

Tim Traylor - 20 Nov 2005 7:15 PM - 6 messages

Hi, I'm having a problem with multiple concurrent users accessing databases. Here's one example: Access 2000. Secured, split database. Back end and MDW file are on a network share. Front end and shortcut w/MDW pointer are on local PC's. ...

Match User Name and Password from Access table

GGill - 20 Nov 2005 7:02 PM - 3 messages

Hi, I have one table 'tblUsers' with UserNm and Password fields. In my 'frmLogin' form i have 2 text boxes txtUserNm and txtPassword and button 'Login'. So I am trying too on click 'Login' button write code, If string UserName and Password match from tblUsers then open some new form for example ...

FORGOT MY PASSWORD HOW DO I RESET IT?

TYCOON - 20 Nov 2005 9:09 AM - 2 messages

...

Re: AllowBypassKey

Tom - 20 Nov 2005 7:46 AM - 14 messages

I have tried this, copied the code and followed instructions. I get error message: "Compile Error: Expected:=" Any further assistance? Thanks ...

logon/unatorised

m.aussie - 20 Nov 2005 5:26 AM - 5 messages

how to find out how is.I suspect someone I know.but how to find out for sure? ...

Winfixer

Mitch - 20 Nov 2005 1:57 AM - 2 messages

Can anybody help me get rid of winfixer? I have tried AdAware, MS IntaiSpyware Beta1, and Spybot. Each time I reboot winfixer reappears. ...