473,320 Members | 1,744 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Database Locks

46
Hi All
I have a application used by 17 users.Each user has a shortcut to the centralized .mdb file.Some times when users tried to enter the values thru input form, a message pops up saying "The database has been placed is a state by user ?admin? on machine "machineno".When i close that application in that macine and restarts the application then every one can again able to start entering the values.Why is it happening.I have checked the mode access its shared ,no lock in database.Can any one tell me why is it happening so.This is my first question in this forum.If my way of question is wrong then do inform me, so that i can post in that manner.

Awaiting reply

Thanks
Regards
Dilip
Dec 5 '07 #1
7 1973
Jim Doherty
897 Expert 512MB
Hi All
I have a application used by 17 users.Each user has a shortcut to the centralized .mdb file.Some times when users tried to enter the values thru input form, a message pops up saying "The database has been placed is a state by user ?admin? on machine "machineno".When i close that application in that macine and restarts the application then every one can again able to start entering the values.Why is it happening.I have checked the mode access its shared ,no lock in database.Can any one tell me why is it happening so.This is my first question in this forum.If my way of question is wrong then do inform me, so that i can post in that manner.

Awaiting reply

Thanks
Regards
Dilip

A lock can occur on a database (the machine details of which you can see by opening the corresponding ldb file in notepad) for a miriad of reasons on a network particularly so if they are all accessing the one mdb centrally somebody for intance might have ctrl+alt+del to name but one example.

You should look at the concept of splitting your database into two db's frontend and backend give each user a frontend file and link to the backend database containing the data.

Have a read of this link

http://www.thescripts.com/forum/thread737435.html

Regards

Jim :)
Dec 5 '07 #2
ramdil
46
Hi

Thanks for the reply.Yes i have splitted the application into two parts that is FE and BE,where FE stands from front end which connects to BE, where BE stands for Backend which is the centralized database.And all users have shortcut to the FE part.But still some times the admin lock error arises.

Awaiting reply

Regards
Dilip






A lock can occur on a database (the machine details of which you can see by opening the corresponding ldb file in notepad) for a miriad of reasons on a network particularly so if they are all accessing the one mdb centrally somebody for intance might have ctrl+alt+del to name but one example.

You should look at the concept of splitting your database into two db's frontend and backend give each user a frontend file and link to the backend database containing the data.

Have a read of this link

http://www.thescripts.com/forum/thread737435.html

Regards

Jim :)
Dec 5 '07 #3
Jim Doherty
897 Expert 512MB
Hi

Thanks for the reply.Yes i have splitted the application into two parts that is FE and BE,where FE stands from front end which connects to BE, where BE stands for Backend which is the centralized database.And all users have shortcut to the FE part.But still some times the admin lock error arises.

Awaiting reply

Regards
Dilip
Does each user have there own frontend file I don't mean a shortcut targetting one frontend file I mean their own actual mdb frontend file

Jim
Dec 5 '07 #4
ramdil
46
Hi
Thanks for the reply.Every user has only a shortcut to the Front end file which is also centralized.Do i need to repair the database...or what else i need to check as it happens once in two days and when i restart theapplication its working fine.Please give me an idea


Thanks in advance

Does each user have there own frontend file I don't mean a shortcut targetting one frontend file I mean their own actual mdb frontend file

Jim
Dec 6 '07 #5
The solution that we used here where we have around 20-25 users all using the same backend is that we created a folder for each user in a centralized location, from there we gave each user a full copy of the front end file. We then created a link on their desktops to make it look like everyone was using the same FE file, but they aren't infact they are linked to their own folder and thus the locks only happen on their front end. Further we created links for them Update Me! that will pull a standardized Most Recent Copy of the front end application so they can update when they get errors that I have fixed. Finally we have a master Update Them file that pushes all updates to unlocked DBs via a command prompt these are both .bat files that run in a command prompt window that echo.

Hi
Thanks for the reply.Every user has only a shortcut to the Front end file which is also centralized.Do i need to repair the database...or what else i need to check as it happens once in two days and when i restart theapplication its working fine.Please give me an idea


Thanks in advance
Dec 6 '07 #6
Jim Doherty
897 Expert 512MB
Hi
Thanks for the reply.Every user has only a shortcut to the Front end file which is also centralized.Do i need to repair the database...or what else i need to check as it happens once in two days and when i restart theapplication its working fine.Please give me an idea


Thanks in advance
Hi Ramdil,

In addition to what owyn999 says you give the user their own file not the shortcut to a single frontend file. You are not splitting it in the spirit of things because one frontend file is being accessed 17 times concurrently potentially and that is where any locks will be taking place in one ldb file on the server because some user or another has eited out wrongly or improperly or a simple network connectivity glitch. I have recently mentioned the same thing to another thread. If you are able to install the frontend file on the client then do so because that way you are running each file then 'per user' under its own steam on the clients installation of Access http://www.thescripts.com/forum/thread745608.html

In addition you are not having to drag the a potentially uncompacted high megabyte file over the network when they double click to open it, A local copy can open up locally to that client machine. The downside is 'distribution' of not having the frontends located conveniently on the server accepted but you could create a logon.bat at network user login to download the latest version from the server to the client. or write into your app version control to deal with that when it opens. Its whatever suits our networking arrangements.

Regards

Jim :)
Dec 6 '07 #7
ramdil
46
Hi

Thanks for the reply.If in mean time if you get you know any other options please let me know

Thanks in advance

Dilip


QUOTE=Jim Doherty]Hi Ramdil,

In addition to what owyn999 says you give the user their own file not the shortcut to a single frontend file. You are not splitting it in the spirit of things because one frontend file is being accessed 17 times concurrently potentially and that is where any locks will be taking place in one ldb file on the server because some user or another has eited out wrongly or improperly or a simple network connectivity glitch. I have recently mentioned the same thing to another thread. If you are able to install the frontend file on the client then do so because that way you are running each file then 'per user' under its own steam on the clients installation of Access http://www.thescripts.com/forum/thread745608.html

In addition you are not having to drag the a potentially uncompacted high megabyte file over the network when they double click to open it, A local copy can open up locally to that client machine. The downside is 'distribution' of not having the frontends located conveniently on the server accepted but you could create a logon.bat at network user login to download the latest version from the server to the client. or write into your app version control to deal with that when it opens. Its whatever suits our networking arrangements.

Regards

Jim :)[/quote]
Dec 11 '07 #8

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

Similar topics

16
by: noah | last post by:
Does PHP have a feature to associate Cookie sessions with a persistent database connection that will allow a single transaction across multiple HTTP requests? Here is how I imagine my process: I...
1
by: cloverme | last post by:
The database is configured for single publisher, many subscribers, merge replication. The maintenance plan started to fail a couple of months ago and the database would not get backed up. After...
1
by: Sergio | last post by:
Hi all! I have a data .mdb file (in Access 2000 format) that's being used by two applications. These applications are built with Access 2K and all this runs under Windows 2000. Each application...
3
by: Leinad Kong | last post by:
I'm using Access 2002, as front-end and back-end as well: 1) I faced database corrupted problems, when more than 1 user edit concurrently. I'm using All-records Locking, and open-exclusively as...
1
by: leon | last post by:
Hi all, I have an .mdb file (access database) which has been set to table level locking (i.e. not just records in question, but the whole table). The database is also in sharing mode (ie. not...
17
by: shineofleo | last post by:
Here is the situation: I wrote a VB programm, which stores all the information in a single Access database file using jet engine. It worked well, however one of my customs reported that there was...
7
by: s w dunn | last post by:
Hello, I am in charge of maintaining a little ACCESS database used by our purchasing department. I need to add some new values to a table, but I can't open the .be database in order to access the...
10
by: giraffeboy | last post by:
Hi there, I'm having a problem with the Python db api, using MySQL. I've written a program with a GUI using wxPython, the GUI is contained in main.py which imports another module - reports.py....
25
by: zmickle | last post by:
Excuse my noobness. I am managing an access database that is shared by 4 users. Management does not want to use any technologies outside of access for this application (no SQL Server, etc). I...
9
by: Sam Lambson | last post by:
Hi, This is similar to another post, because I still haven't gotten to the bottom of it. I have a back end database on a shared drive. Each (of 4) user has a front end file on their own C:...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.