MSACCESS LDB Problems
I have an issue that is tough to solve. When I am in my MDB I am not allowed to modify my MACROS. Reason, Someone else has access to it and I don't have exclusive rights. I have a FOrm I added to my MDB called LDBVIEWER which shows me , VIA Jet 4.0s userroster, the users active in the LDB file. The LDB file as you know manages the active users of the MDB. I am listed Twice in the LDB while I have the MDB open. If I was listed Once then I would be able to work with my MDB exclusively.
Any Ideas on how to fix this. Already tried to Reboot. And my MDB is on a network drive - And my Terminal ID is listed twice so it isn't open from two different places. I don't have MSAccess running twice. In essence when I close my MDB the LDB file will remain. I want to kill it.
Any Ideas how to KILL users in the LDB?
Thanksss
[889 byte] By [
bar23] at [2007-11-11 8:34:57]
# 1 Re: MSACCESS LDB Problems
You might want to try using the Process Explorer ( http://www.sysinternals.com/Utilities/ProcessExplorer.html) utility to identify which processes on your machine have the database open.
# 2 Re: MSACCESS LDB Problems
I like that program. However, I had my Operations department check for it and it looks like the MDB and LDB are tied into a SYSTEM process. Only a reboot of the server will clear them out. So this helped. I thank you for the response.
Bar23
bar23 at 2007-11-11 23:48:00 >
