Locking Down Access '07

Mar 19, 2007

So with the help of many of you on this site, I was able to build my first Access database. Thank you all.

Now that I'm all done, I have one final thing to figure out.

I have incorporated user authentication into the database for a minimal level of security. Everything finally works like it should, however there is one "flaw" I have found.

In "Access Options" I have the login form set to open when the DB is open, and navigation and ribbon/toolbars are deactivated so only the login form and "Home" ribbon are showing when the DB is opened.

The problem with this, is that a curious user that shouldn't have access could get access fairly easily.

If they right clicked the "Home" ribbon, then left clicked "Customize Quick Access Toolbar", they could change the default form to whatever they wanted. Thus bypassing the login form and nullifying any security that it offered. Ideally, there should be no ribbons or toolbars. I just don't know how to get rid of them.

Has anyone else run into this problem?

View Replies


ADVERTISEMENT

Locking User Access To Database Objects (MS Access 2000 And 2003)

Apr 15, 2007

I have two database applications and they are:
- the (A) application is for administration use.
- the (B) application is for normal users use.

the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).

the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.

but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data.

The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.

I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.

View 1 Replies View Related

Locking Of Access Database.

Nov 29, 2005

I have prepared an access database on a shared drive location(lan) with 5 tables. The main table has over 110 fields and is linked to a form. On an average the table stores 12000 records, which are updated via a form.

Normally, 7 users work on this form and do add/change/delete operations on the records.

The frequent issues I face are:
Corruption of records.
"Could not update, currently locked" errors.

I have constantly tried compact and repair option, but the same does not give required results.

Kindy advise a solution.

View 2 Replies View Related

MS Access Record-Locking Information

Mar 31, 2006

Hi,

I have a question.

Does anybody know about "MS Access Record-Locking Information"?

And, the file extension is .xxx

Only one person can open the file.

Does anybody explain to me and teach me how to make/solve it?
Or, offer the link about it to me?

I want to know that.

Thanks a lot.

View 1 Replies View Related

Access Record Locking Confusion

Oct 6, 2006

In OPTIONS -> Advanced I have the option Open Database using Record-Level locking ticked.

What is strange is record level locking works on Form1 (Form1.recordlocks= Edited) as long as Form2 has Form2.recordlocks = No Locks. If I change the Form2.recordlocks = Edited, Form1's locking becomes page level locking.

This is even true if Form2 is not open...

Additionally, Form2's locking is always page level locking if Form2.recordlock = edited.

I would like all my forms to perform RECORD level locking not page Level locking. How do I accomplish this.

I've been trying to resolve this issue for about 2 months now but no answers from the community.

Thanks for any comments.

View 8 Replies View Related

Access Locking Up With Multiple Users

Mar 12, 2007

Hi,

I have a database that i created for our tech support team. I have split the database and have given the 3 users each a shortcut. I als e only installed Access Runtime on their machines.

The first user in pilot testing had no issues and we have just added the other 2 users. At first all was well. However, the 2 new users are now having periodic lock ups where they go to enter a new record and the dbase freezes on them. It seems to release itself in a few minutes, but this does not help my productivity.

My original user is still not having any trouble. Does anyone have any ideas of something that perhaps I missed? Everything I have read, suggests that 3 users should not have any trouble using a split dbase.

Is it runtime that may be causing this? I have considered going to full versions if need be, but then I would need to figure out how to lock it down better.

Thanks
Dave

View 14 Replies View Related

Locking Fields In Access Form

Jun 4, 2012

I have 4 questions (4 fields) in a form. 2 are drop down menu type and 2 are open text fields.I would like to limit the user from entering data in the fields if one has been answered. for example: if Question one is answered, question 2, 3 and 4 should be locked and should not allow the users to fill in anything. How do I create that Locking system?

View 10 Replies View Related

I Have Two Ms Access Record Locking Information Open

Jul 19, 2006

I have some security issues going on all of sudden. I now have 2 Record locking information files on my drive. I have several users sharing the database. Any clues why this is happen?

View 2 Replies View Related

Microsoft Access Record-Locking Information

Feb 8, 2006

Hello Everyone,

I have an access file (a Form) that I put in the network and it's accessable thru a web site inside our company(intranet). I setup the database to be on shared mode so everyone can access it at the same time. The problem I'm having is that when someone open the file, access creates another file called "Microsoft Access Record-Locking Information" which still active even after users close the form and their web browser and this doesn't allow me to edit the file if I need to make changes. Is there a way to deactivate this record-locking file? The only way I found out to be able to access the file after someone used it, is having the user go into their Task Manager and delete MSACCESS.EXE from the Processes tab. Any inputs would be greatly appreciated.

Pablo

View 7 Replies View Related

Locking Field Once Changed In Access 2000

Mar 30, 2005

Hi,

Im a relative access newbie, and am updating an already created form. I want the user to be able to change the value in a field , then when they exit the field, for it to be greyed out, so that no more editing of the field is possible.

I know how to lock the field in design view, but I want the field to lock after the user has amended it. Is this possible?

Many Thanks!

View 4 Replies View Related

Is It Possible To Access Specific Records Without Locking The Whole Table?

Nov 19, 2007

Is it possible to access specific records from a Microsoft Access table without locking the whole table?. I have different processess accessing at the same time different records from the same table and I getting an execption, indicating the table is locked. Can any one provide me some help regarding how to access specifi records without locking the whole table in MS Access?

View 1 Replies View Related

Must Use File Open Command In Access To Achieve Record Locking

Mar 2, 2007

It just read in Access Help that if you have open db using record locking checked that you must open the database using the File=> Open command from the MenuBar. Does anyone know anything about this or can anyone comfirm this a s true?

View 6 Replies View Related

Modules & VBA :: Record Locking Multi-users Over Network Split Database / Access 2007

Aug 5, 2015

I have designed a database which I intend to split for multi-users to access from one front end icon on a shared folder at work. I have designed a form bound to cmr record table and on it a subform to another table where cmrs activities will be saved. The form has buttons to and blank controls.

User can create a new activity entry by typing into the blank controls and pressing the save button which saves to the activity table. the edit button extracts a selected records details (selected on the subform) from the activity table and populates the blank field for a user to edit and then hit save to save changes. The delete button deletes a selected record from the activity table. I intend to have multi-users either accessing, viewing and a possibly editing the same customer at the same time. The simultaneous viewing is essential but the simultaneous editing, though not desired is inevitably going to occur.

What I would like to know is:

1. Can you lock an individual record in a table or does the whole table have to be locked. E.g If Colleague 1 is editing Cmr A's record in Table1 can he lock it so Colleague 2 can view and edit Cmr B's record in Table1

2.Can Colleague 1 access/read Cmr A's record in Table1 to retrieve details toe the form controls if Colleague 2 is viewing or editing Cmr A's record in Table1

3. If record lock is possible, how can I initiate it in my example code below.Edit activity record Code

Code:
Private Sub Edit_A_Click()
'Get Data to text box control
With Me.R_P_Data_P_Subfrm.Form
Me.txtrID = !rID
Me.txtrID.Tag = !rID
Me.txtrefNo = !refNo
Me.cmbrpc = !rPC

[code]....

View 8 Replies View Related

Locking A Database

May 8, 2005

I have a company wanting to asses my database and i am willing to show them but i need to be able to lock the database so that they can view it but cannot edit anything in it either adding deleting or plan editing. How can i do this.

Bullfrog
The Amateur

View 4 Replies View Related

Split DB, Keeps Locking Up

May 24, 2005

Hi, I just recently split my Access db (FE/BE), copied the FE to each of the clients, and it seemed to be working fine. This morning however, two users went into the db, and the second user kept getting the error can't find the file \servernameshare_namedb_fe.mdb. Now, none of my users can launch it. How can I resolve this? Will this keep happening?

AP

View 1 Replies View Related

Locking Down An .mdb File

Feb 8, 2006

I have to send an access application out to some people who need to preview it's functionality. What is the best way for me to send this .mdb file to them so they can use it (tables, forms, queries, macros and functions) but still keep them from opeing up the objects and viewing the code behind them? Is there a way of sending the .mdb file out so that objects cannot be seen in design mode and the objects cannot be viewed other than through the flow of the application? As you might have already guessed, I am new at securing an .mdb file for outside use. Your help would be greatly appreciated.

Thanks!

View 4 Replies View Related

Complete Locking

Apr 5, 2006

Hello Everyone,

I just migrated a back end to a network server. Now when more than one tries to use the database they get a file in use error.

Any ides?

View 3 Replies View Related

Locking A Invoice

Jan 18, 2007

Hi,

I don't know whether you can help :D But i am in need of some code/guidence, or a way to go about trying to do what i want to achieve.

Basically, i am creating a invoice producing software in Microsoft Access, based upon Computing parts resaleing.

Because the supplier, i use changes the prices daily, when i type the products into the Parts Table, the price being typed in will change for the next customer to have the same part.

Basically because i am using this software to produce Profit and Loss, The invoice will be looking back at the Parts table, and changing the unit costs for invoices which are say weeks old.

I am wondering whether i can "lock" the invoice so it cannot be updated from the Parts list and keep the profit the same, so i get an accruate result when i come to look at it.

I will apprechaite any help or guidance.

Regards

PC_Doctor

View 4 Replies View Related

Locking Table

Aug 7, 2007

How Can You Lock Table Or Form So Nobody Can Accidently Delete It Or Alter It Unless Person With Permission?

View 1 Replies View Related

Locking Database

Dec 6, 2007

Hello,

As my username states, I am a rookie to MS Access. I built a database using Access 2002, I will distributed it to other people, I will like to lock changes to certain areas such as forms, design view, etc.

Can this be done? The help is greatly appreciated!

Rookie2007

View 14 Replies View Related

MDE Locking Issue

Jan 15, 2008

I have an Access Front-end that I made into an MDE file. I loaded the MDE onto a server and now there are multiple people accessing the MDE file via shortcuts on their desktop. I noticed since this update went into effect that the MDB file that the MDE file was made from is being locked when people are using the MDE file. I thought I could have made a mistake with one of the shortcuts and that a user was accessing the MDB file instead of the MDE but I had the Network Admin check and no one was in the MDB file at the time it was locked.

I'm wondering if the MDB file should be locked while a user is in the MDE file or if it's a bug?

Thanks,
Michael O'Brien

View 1 Replies View Related

Locking Down Records?

Feb 13, 2008

Is there any way to "lock down" newly created records somehow, so that only the person who created them can edit them after the fact?

Obviously, this would require some kind of system where everyone logged in with some kind of userID and password...and even then, I don't know how such a security system could be set up.

Is this possible? If SO, are there any examples of it anywhere that I could check out?

Thanks in advance!

View 2 Replies View Related

Locking A Record

Mar 14, 2008

is it possible once a record has been entered, to lock it so that it can not be changed by just anyone but that the administrator could change it using a password?

View 6 Replies View Related

Why Is Locking Occuring?

Feb 8, 2005

I have a fixed length .txt which I am linking into a MS Access 2002 d/b.
My options are set to :
default open mode -shared
default record locking - no locks
Open database using record level locking is unchecked
the (datasheet) form is set to:
allow edits/deletions/additions - no
recordset type - snapshot
record locks - no locks
the text box objects are set to:
enabled - no
locked - no

I have no requery actions associated with any events at all.

My problem is that while the form is active I am unable to open the source .txt and if it is already open I cannot save it. There is obviosuly a lock occuring on the .txt object - how can I prevent it occuring?

thanks!

Gordon

View 2 Replies View Related

Locking A Database

Feb 17, 2005

I have looked on the forums and cant quite find what im looking for so i wanted to ask you lot for help.

I have a database i have created.

It will be sent out to people to populate via a series of forms i have created.

How can I lock it down so that:
1) you cant access any of the database apart from the forms
2) Lock it so no one can get in to view the code anywhere or make any amendments to the forms and database what so ever

View 3 Replies View Related

Records Locking

Aug 11, 2005

I update the table through a form.
Each page in the form updates one complete row of the table.

I am trying to find a method to block each row of the table (or equivalenty each record in the form) after completing the entry in order to prevent unwanted deletion or alteration of the entries of this record in the future.
Is this possible?

View 2 Replies View Related







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