Access Security - Week 38, 2006

how can i find my missing folder

sexy - 22 Sep 2006 8:23 PM - 2 messages

...

can use code to reference mde file?

Jay - 22 Sep 2006 8:16 PM - 6 messages

Does anyonw know how to use vba code from mdb to add or replace a reference to an mde file? Thanks in advance ...

Ugh! Permissions dilema...

Bonnie - 22 Sep 2006 3:59 PM - 14 messages

Hello everyone. I'm using A02 on XP. DB is an old A97 that was converted up to A02. Have a user group with edit rights and they work fine on one form but not on another. I cannot figure it out! I've checked the permissions ...

Workgroup - back ups

Johanna Gronlund - 22 Sep 2006 2:21 PM - 4 messages

Hi, The previous person in my post created a database for the organisation to use which is secured using workgroups. I am now having to make some changes and trying to make a backup. The problem is that when I try to open the ...

Whare are permissions stored?

Not_A_Real_Programmer - 22 Sep 2006 1:18 PM - 7 messages

In a split db, where are group permissions actually stored -- in the .mdw file or in the FE? I keep setting group permissions and they keep changing. ...

How do you password protect a form

KAREN27 - 21 Sep 2006 5:11 AM - 4 messages

Hi all, I have created an Access 2003 database that when opened it shows only the mainform that has command buttons that access various other subforms. One of these subforms is an input form from where you can enter data ...

Command Button Password

Roger Bell - 21 Sep 2006 1:38 AM - 10 messages

Could anyone tell me if it is possible to write some code into the "Onclick" Event procedure that requires a password before the user can access a command Button or Ctrl Tab? Thanks for any help ...

Audit on Access

Billy - 20 Sep 2006 8:31 PM - 3 messages

Hi People, I am wondering if there is a way to audit access database and be able to track down who used the database, what changes were made and the time changes were made. This is a feature in many database ...

Hiding Backend Files

Sprinks - 20 Sep 2006 8:16 PM - 8 messages

I have implemented security on the front- and back-end files for a timesheet application, and after 2 days of testing, everything seems to be working as expected. It occurs to me, however, that there is nothing preventing a ...

MVP Question

Trey Davis - 20 Sep 2006 4:36 PM - 4 messages

Is it possible for me to become an MVP? And how do I block messages from a particular user? Is there a way to identify a user's IP address, and block this IP address so that message doesn't show up in my Outlook Express? ...

Another question about removing security

Andrew B - 20 Sep 2006 4:19 PM - 2 messages

Hi, I'm in a bit of a bind. I have been given a copy of an Access 97 database that has security already set up. I have the shortcut file, the .MDB file and the .MDW file. I am using Access 2002 on my PC. I can log on to use the ...

Can i require password from operating system for mdb file to open?

abelinthecommunity - 20 Sep 2006 3:52 PM - 13 messages

Can i limit an access mdb file to a given set of machines by loading into the machines a password that the mdb file looks for before opening so that it will not work on other machines? The idea is that a user would not be able to ...

Security log ins

Matt Dawson - 20 Sep 2006 3:09 PM - 15 messages

I currently have a database in Access 2003 with user permissions and passwords. When the relevant user logs in they go to the form and assign themselves to a job. However, at the moment it would be possible for them to sign in and assign a ...

Multiple Users on an 2003 Access Database

AlanK - 20 Sep 2006 9:39 AM - 2 messages

I have set up an Access 2003 Database. Multiple Users will have to be able to work on this database at the same time. (i.e. two users can create a query on the one table at the same time). ...

how to import form,report or module objects with project security

Jay - 19 Sep 2006 8:14 PM - 4 messages

Is there a way to supply the password in VBA code to allow an mdb file to import objects from another mdb file? My issue is if my mdb has project security turned on and tries to import objects from another mdb file, I get the message, ...

Auto join to MDW

Pendragon - 19 Sep 2006 5:40 PM - 7 messages

From info on other posts, I have set my shortcut to the following: "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Database\FSCorp.mdb" /wrkgrp "p:\DataWH\FSCorpUsers.mdw" where p is our network drive. Opening the database through the shortcut did in fact get the login prompt. ...

References

Sprinks - 19 Sep 2006 4:14 PM - 4 messages

I have several general purpose functions and procedures that are used across several database applications. After tiring of cutting and pasting and maintaining multiple versions of the same code, I copied them to a new database "CodeLibr". I set a reference to this file, which is stored in a shared folder on the ...

mdw file move to shared network drive

jimmy g - 19 Sep 2006 4:09 PM - 4 messages

i want to move the mdw file created on my local drive to a network drive ? when i copy or move the local version my access files located on the network won't open ...

Listing current users at startup on the autoex form

Leroy-P - 19 Sep 2006 2:19 PM - 10 messages

As an administrator, I need to know who is logged into the data base at openning screen, so I can notify they to exit, if the need arises? How do I do this, would I use the CurrentUser() and do I do that? ...

trying to send a secure file

babs - 19 Sep 2006 1:55 PM - 6 messages

I am trying to send a zipped up secure file via outlook and it is hung up in the outbox- it is 22MB zipped up anyway I can compress it more. Thanks, Barb ...

Exclusive Access

Clois Beckwith - 19 Sep 2006 1:35 PM - 11 messages

I am the administrator of the database, I am in the Admins Group with no permissions for the Users group. When I try to open the backend or the frontend in exclusive mode, it is set for Shared Access for the database. My ...

prevent import /export

S - 19 Sep 2006 12:13 PM - 4 messages

I want to give the user permissions to alter, insert and delete data into the tables but I don't want them to be able to export the tables or import them from inside another database. How can I do this? ...

Rights For ASP Connection To Access DB

Art Cabot - 19 Sep 2006 12:26 AM - 3 messages

I have an Active Server Page talking to an Access database on IIS6. What rights are needed to the folder where the .mdb resides in order to write to the tables? This is on a corporate server where they REALLY have things secure! ...

Baffled By Security Wizard

Sprinks - 18 Sep 2006 10:29 PM - 7 messages

I am attempting to secure some currently unsecure databases to an existing workgroup. After adding a Group that I needed, I joined the workgroup, opened the first database, and ran the Security Wizard. It seemed to work, and I verified that the Users group had no permissions and that the Admin ...

"Save Action Cancelled"

Clois Beckwith - 18 Sep 2006 6:33 PM - 5 messages

I am getting the following in the Subject Line. This happens on two forms in my frontend and I have checked the code for the forms and controls and neither the form or the controls have a DoCmd.Save written into the code or ...

Missing Toolbar

Sprinks - 18 Sep 2006 5:35 PM - 3 messages

After failing to properly secure a database, I logged onto my workgroup file and imported all objects into a new database and set permissions. This succeeded in securing my file, but the custom toolbar did not come with it. ...

Causes of Corruption??

Bill - 18 Sep 2006 3:31 PM - 5 messages

Hi All, I have setup a shared secure database using an mdw file and a batch file to launch. The database has been working fine for several months now but today for the second time it has corrupted. The nature of the corruption varied but in each case I reckon we could have ...

A way to show menus in Acces when turned off in startup?

Richard - 17 Sep 2006 6:41 PM - 2 messages

I turned off menus in Startup and my backup file was corrupted. Is there a way to reaccess the database window once this option has been set? ...