Security Newsgroups: Access Security

floating ads, how do I get rid if them

T5 - 19 Nov 2005 10:42 AM - 2 messages

You know these really annoying floating ads that float across your screen saying that you have won something or advertising holidays etc, how do you get rid of them? ...

anonymous surfing

T5 - 19 Nov 2005 10:41 AM - 2 messages

Hi, I am using ghostsurf on full secure setting so how come my isp can still be traced by whatismyip and online trojan scanners etc? Shields up from Gibson research also reads my address as do broadband speed testing sites, I am ...

User acct and group management forms/code?

kiln - 19 Nov 2005 5:41 AM - 8 messages

Does anyone know of an Access book or website that has decent group and user managment example forms and code? I would like to offer user creation etc, group memberships, password management and so forth to end users via regular Access forms, not the built in dialogs that Access ...

forgot document password how do i get around

mikey - 19 Nov 2005 1:08 AM - 2 messages

i forgot a pasword for a word document please help i need this ...

Lock a Table

Kimon - 18 Nov 2005 6:09 PM - 3 messages

Dear Sir/Madam, How can i create a database file which inclunding lock data ? (such as MSysObjects ? ) ......I want to create a table which inclunding data that the user can not edit and modify also the structure of the table. ...

Edit error message

Swish - 18 Nov 2005 7:16 AM - 2 messages

Hi, I created a few forms and a security system that disallow certain users to run those forms. When unathorised user try to run the forms, an error message will pop up. However, 1 of the options on the error message is "Debug". By pressing that ...

user actual name

Alex - 17 Nov 2005 7:10 PM - 10 messages

Hi, It's easy to identify the user login name. But, is there any way to identify the actual user name - the first and last name? Using something that exists in dotnet DirectoryServices.DirectoryEntry; System.DirectoryServices.DirectorySearcher; etc. Thanks ...

Making a database read-only for most, but still editable by author

Katie - 17 Nov 2005 6:08 PM - 2 messages

I have the database split between a two front end databases and a back end. One front end has full access forms, another has read-only forms. Each of the three has a password, to limit access to those who are authorized. ...

secured.mdw corrupted

Bill Johnson - 17 Nov 2005 5:45 PM - 8 messages

When entering a secured DB this morning, (Access 2003, mdb) the user received the error: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." This appeared before even getting the login dialogue box. I've searched ...

Encripting data fields

Nuno Guerra - 17 Nov 2005 10:54 AM - 3 messages

Hi. I have an aplication with a User Login Form. It saves the users passwords in a table field users. For security reasons i would like that the table field with the password users could be, in a certain way, encripted. ...

IRM on office 2003

Dan - 17 Nov 2005 9:52 AM - 2 messages

1.After I checked restrict permision to this document I give it the "change" rights to j**@domain.com.That's fine.But I don't want Jon to be able to save the modified document locally--> save as must be invalidate like for "read" ...

Setting up password protection in a different State

Alex Martinez - 17 Nov 2005 6:29 AM - 3 messages

Hello, My company is in California and we have a branch in New York I have access to the branch server and folder. I am creating a database using Access 2002 in which there will be about 10 users. What I want to do is to start ...

Access Password

James_101 - 17 Nov 2005 3:12 AM - 3 messages

I am running Access 2000 on Win XP Pro. I have several Access databases. On db #1, I set a password and all works correctly. On db #2, I set a password and it operates correctly when I open ...

Deploying the FE to the users?

KReese - 16 Nov 2005 10:36 PM - 2 messages

I created a database with user level security. I made a copy of that database; made one a FE & one a BE. They are both secured & cannot be opened without the shortcut with the wkgroup switch. ...

jet 4.0SP8 for XP is not resolving secuiryt issue with access 2K3

al - 16 Nov 2005 10:31 PM - 2 messages

Microsoft recommneds that you install Jet 4.0 SP8 to resolve Access 2003 secuirty problems, when I try to do so on a Windows XP machine it tells me that my Jet version is newer than the one I am trying to install, but my ...

ShellExecute with Mdw file

Weste - 16 Nov 2005 10:09 PM - 4 messages

I am trying to use the ShellExecute function to open an access database with a mdw file. Below is the code I am using. lngRet = ShellExecute(Me.hWnd, "open", """c:\test\mdw test\secure test.mdb""", "/wrkgrp ""c:\test\mdw test\secure.mdw""", "", 1) ...

How do i find out who else is using a database?

icenate - 16 Nov 2005 3:41 PM - 2 messages

How do i find out who else is using a database? ...

Controlling access to confidential data

HRman - 16 Nov 2005 3:31 PM - 2 messages

Hello, I have a table containing salary information. I would like to give people access to queries which show only the parts of the data they are responsible for and not the rest of the data. I have set up a number of queries which ...

migration from access 2000 to 2003

Alan - 16 Nov 2005 12:15 PM - 3 messages

I have created a secured database under access 2000 running on Windows 2K. I also created a shortcut, contining command line parameters to point to the correct workgroup file, to launch an application within said database. Every thing worked fine and dandy. Now I copy the database, workgroup file ...

If statement regarding current user

Kathy Webster - 16 Nov 2005 1:26 AM - 3 messages

I have a runtime app. If the current user is a "readonly" user, I want a certain macro to stop. So I have a successful condition statement in the macro that says : Currentuser()="ReadOnly" I would rather assign this condition to a GROUP, rather than an individual ...

Workgroup File Crossover Problem

robert d via AccessMonster.com - 16 Nov 2005 1:20 AM - 4 messages

I have the following situation: 1) DB#1 (front end) - WRKGRP File #1 used to secure it - Owner is DBOWNER - uses RWOP queries - links to backend following Access Security FAQ 14.3 (no permissions linking) 2) DB#2 (back end) - WRKGRP File #2 used to secure it - Owner is DBOWNER - ...

Login to FE as 2 different users?

JWS315 - 15 Nov 2005 11:06 PM - 22 messages

Ok - I should have read all about security BEFORE I spent months and months designing and developing my application (ARG!!!). Here is my delima - I have over 150 SQL statements in VBA code and have setup user level security - when ...

Annoying popup.

Frank Martin - 15 Nov 2005 9:18 PM - 3 messages

I have just upgraded from Access2000 to Access2003 and every time I start it up I get popup security message How can I turn this off? Please help, Frank ...

How Do You Re-enabe the Shift Key Without Access to the Immediate Window?

Brian Smith - 15 Nov 2005 8:47 PM - 6 messages

Is it possible to re-enable the Shift key when you don't have access to the Immediate Window? I have administrator permission on the database (I'm the owner) and thought I could do this from another database that uses the exact ...

no login prompt

Rocky - 15 Nov 2005 7:13 PM - 10 messages

I have created a database on my computer, utilized the Security Wizard and followed the instructions exactly and things seemed to be working as anticipated. However, suddenly, my machine will not display a login box when I try to access the secured database nor will it allow me into the database ...

Access is now opening in "Read Only"- I want to remove this.

dapetrella - 15 Nov 2005 2:46 PM - 2 messages

My db suddenly now opens in "Read Only". I want to restore open access so that I can add, edit data and objects. ...

problem when using system.mdw

John - 15 Nov 2005 7:01 AM - 3 messages

Hi, I have trouble when using the file system.mdw. In the application I use, I have to switch to a system.mdw on the server. This file was shared by all users using the application. However, when I join that file and then run the ...

CORRUPT MVP's -RIGHT HERE!!!

Chris Mills - 15 Nov 2005 6:16 AM - 3 messages

In case anyone thinks I have gone away on the subject of MVP corruption in matters of Access Security, not by a long shot and I will name them here. I apologise that, due to the southern hemisphere summer, I am spending more ...

access security and XP Networks

New TO Access - 15 Nov 2005 2:59 AM - 2 messages

I have an Access database that has security. A number of users utilise the database (with different permissions) but to date it has only been resident on a stand alone PC. I recently moved the database to a PC that is on an XP network, albeit only ...

WPA2 or Not?

fredmertz - 15 Nov 2005 1:29 AM - 2 messages

I have a Linksys router with desktop that show WPA2-PSK configuration and I have everything checked for that mode. My laptop shows "TKIP, WEP, AES" under data security and the connection is authenticated. I've downloaded what ...

My view is locked HELP

TIMCEC - 14 Nov 2005 11:01 PM - 2 messages

I locked my view in user mode is there a way out or will I need to recreate the entier database. PLEASE HELP!!!! ...

802.1X, Windows supplicant & Microsoft IAS

Guillaume Tamboise - 14 Nov 2005 8:24 PM - 2 messages

Hello, I am trying to set up 802.1X for wired access. I have two kinds of clients, running Windows 2000 and Windows XP, but all the following tests are carried out on Windows XP SP2. IAS is running on a Windows 2000 server (SP4), that is also an AD domain ...

Upgraded Access won't allow editing

rwrussell2 - 14 Nov 2005 8:10 PM - 2 messages

We have a small office network and have been using Access 2000 for a simple job tracking database. We have replaced a few of the computers on the network with new computers and installed Office 2003 (Access 2003). On 2 out of 3 of the Access 2003 machines we can open the database and move ...

How to tell who has db open on a network?

naiveprogrammer - 14 Nov 2005 6:41 PM - 7 messages

How can I tell what user has my database open? The DB is on our network drive. Thanks! ...

startup password

John Lane - 14 Nov 2005 4:01 PM - 3 messages

How do I get around the startup password? I was given an app to maintain and the original developer left without telling anyone the password. Thanks. ...

how to make labels for multiple recipients using outlook contacts

phyllis - 14 Nov 2005 2:41 AM - 3 messages

I am wanting to send Christmas cards for multiple recipients using addresses I have created in Microsoft Outlook. Please!! ...

Re: Secured Temp database

TC - 14 Nov 2005 1:21 AM - 24 messages

It is not the owner of the /link/ which is important to an RWOP query. It is the owner of the /query/. You need to ensure that the owner of the RWOP /query/ has sufficient permissions (whatever those may be) to ...

Logon Problems

ScheibleAssociates@sbcglobal.net - 13 Nov 2005 7:36 PM - 2 messages

I had been using my laptop (Windows 2000 Professional). The next morning, I attempted to logon and the computer didn't recognize my password ! my user name was properly filled in, but I kept getting the default message saying my ...

Dual Workgroup - Problem with creating administrators

robert d via AccessMonster.com - 13 Nov 2005 6:10 PM - 2 messages

I have created a second workgroup file (different from my developer file) for distribution of my database. I followed the Access Security FAQ (Item 33). It works and I can log on to the application using this second workgroup file. ...

User timeout

John.bb - 13 Nov 2005 1:38 PM - 3 messages

I have a multiuser database. An audit trail is kept of records as they are updated. However, users can share a workstation and this can compromise the audit trail if a user forgets to sign out or sign in. Is there a way of setting a time out similar to a windows desktop that shuts ...

Disabled Shift Key

felicitea - 13 Nov 2005 4:53 AM - 3 messages

Can anyone tell me why the Shift key (to bypass startup properties) is disabled on a database when it is running on a machine with Access 2003, but when the database is copied to an Access 2002 machine, the Shift key is not ...