By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,425 Members | 2,549 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,425 IT Pros & Developers. It's quick & easy.

current Data has be locked by another User

P: 6
Please am a Programmer and have design a Complex software for generating student Bill and Report.I used Access to design the Database.Everything is working Properly but my problem now is that when I network the computer to Other clients computers.My clients are not able to enter Data at the same time.It gives a prompt message that "Another User Is Accessing the Same Information".Please How do i solve this.Am really in need of Help.Thank you.
Feb 21 '07 #1
Share this Question
Share on Google+
10 Replies


ADezii
Expert 5K+
P: 8,638
Please am a Programmer and have design a Complex software for generating student Bill and Report.I used Access to design the Database.Everything is working Properly but my problem now is that when I network the computer to Other clients computers.My clients are not able to enter Data at the same time.It gives a prompt message that "Another User Is Accessing the Same Information".Please How do i solve this.Am really in need of Help.Thank you.
Check your Record Locking Scheme: ==> Tools ==> Options ==> Advanced ==> Default Record Locking
Feb 22 '07 #2

lee123
100+
P: 556
I Have A Quick Question, Is There A Way You Can Burn Your Database Onto A Disc With Out It Saying (read Only), And If So Please Tell Me How I Would Appriciate It Very Much
Feb 22 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
I Have A Quick Question, Is There A Way You Can Burn Your Database Onto A Disc With Out It Saying (read Only), And If So Please Tell Me How I Would Appriciate It Very Much
You cannot hijack this thread you must post a separate question.

ADMIN
Feb 22 '07 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
Check your Record Locking Scheme: ==> Tools ==> Options ==> Advanced ==> Default Record Locking
I recommend changing the setting from 'All Records' which I assume is the current setting to 'Edited Record'.

Mary
Feb 22 '07 #5

lee123
100+
P: 556
well thank you for setting me straight but im new to this and don't know how to (just post a separate question) so tell me please and sorry adezii for hijacking your thread. but for you admin. i think you should of known if a person did hijack he/she doesn't know what he/she is doing right!
Feb 22 '07 #6

MMcCarthy
Expert Mod 10K+
P: 14,534
well thank you for setting me straight but im new to this and don't know how to (just post a separate question) so tell me please and sorry adezii for hijacking your thread. but for you admin. i think you should of known if a person did hijack he/she doesn't know what he/she is doing right!
There are lots of reasons why members hijack threads. I try never to assume.

To post your own question go to the forum main page and look for an orange button above the list of threads on the right called 'Start a discussion', this will open a window for you to post your question.

ADMIN
Feb 22 '07 #7

P: 6
I recommend changing the setting from 'All Records' which I assume is the current setting to 'Edited Record'.

Mary
Thank you very much.I will check and see.
Feb 22 '07 #8

P: 6
Thank you very much.I will check and see.
Thank you for your help.But i still experience the same problem,This time it tells me that "The current Data has be locked by another User" when two people are accessing information at the same time.
Please help me
Feb 23 '07 #9

MMcCarthy
Expert Mod 10K+
P: 14,534
Thank you for your help.But i still experience the same problem,This time it tells me that "The current Data has be locked by another User" when two people are accessing information at the same time.
Please help me
This should only happen if they are trying to edit the same record at the same time which they shouldn't be allowed to do as it can cause corruptions.

I assume the default open mode is set to Shared and not exclusive as this wouldn't let them open anything but a read only copy of the database.

Mary
Feb 24 '07 #10

NeoPa
Expert Mod 15k+
P: 31,494
Another reason this may occur is if the design of the database doesn't allow for a multi-user situation.
It sounds like you started it off as a single user database and then tried to use it in a multi-user environment.
This often fails as the considerations for a multi-user situation should really be designed in from the ground up.
Feb 26 '07 #11

Post your reply

Sign in to post your reply or Sign up for a free account.