Feb 22 2006, 09:13 AM
I am doing devoloping work on an Access database and things are getting locked up mysterousily.
I am thinking that there may be some conflict with someone or something is going on in the code.
Is there an easy way to check on who is using the database? Everyone has a log on name and it is networked on a server.
Feb 22 2006, 09:16 AM
Have you split the database front end and backend.
Is the back end on the server and the front end held on each users own desktop?
This might solve all your problems.
Feb 22 2006, 09:40 AM
Just to add, you can open the .ldb file that is generated when the database is locked. Open it with Notepad and it will give you a somewhat accurate picture of who has the database open. I say somewhat because it is essentially a log file that is appended to whenever a new user opens the database and will not be purged until all users have exited the database. So there will be records in there of people who no longer have it open but did have it open at some point during the entire time the db has been open.
Feb 22 2006, 09:50 AM
Thanks for the input I forgot about checking the ldb file. I downloaded a tool that gives a nice gui
Access workbench maybe I should not have bothered.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here