Hi,



I've a secure database where the front end crashed on a user. Now, even 

though said user does not have the database open, the .LDB file shows 

she's still logged in. What's worse is that she can no longer edit certain 

records (I suspect because of record locking). How can I close this 

instance of the application, so my end user can use the database to edit 

data?

--0-929503234-1008184996=:63005

Content-Type: text/plain; charset=us-ascii





 I run into this when users turn off their machines without properly exiting the Access application. All I do is log on again and
then properly close out. The ldb file goes away for me after that.

 

  patrick slesicki <patrick_slesicki@d...> wrote: Hi,



I've a secure database where the front end crashed on a user. Now, even 

though said user does not have the database open, the .LDB file shows 

she's still logged in. What's worse is that she can no longer edit certain 

records (I suspect because of record locking). How can I close this 

instance of the application, so my end user can use the database to edit 

data?






Lonnie Johnson ljprodev@y... 

ProDev, Builders of MS Access Databases

Let ProDev build your next MS Access database application. 

http://www.galaxymall.com/software/PRODEV 



Get paid cash every time you receive email!

Sign up FREE at: http://www.MintMail.com/?m=975303





---------------------------------

Do You Yahoo!?

Check out Yahoo! Shopping and Yahoo! Auctionsfor all of your holiday gifts!

Have just attempted opening and closing it properly with no luck. By the

way I'm working w/ Access97. Any more ideas?

I ran into this.  Is this an Access database being used over the

network?  If so, this might be like my experience.  I had to get a

server admin to track down the .ldb file on the server and kick the user

(which was me) out of it.  For whatever reason Access locked my username

in there and refused to release it.



-----Original Message-----

From: Patrick_Slesicki@d... [mailto:Patrick_Slesicki@d...]

Sent: Wednesday, December 12, 2001 2:35 PM

To: Access

Subject: [access] Re: .LDB file show user even when database is closed







Have just attempted opening and closing it properly with no luck. By the

way I'm working w/ Access97. Any more ideas?

--0-541718286-1008188691=:87277

Content-Type: text/plain; charset=us-ascii





 Open, Compact then Repair.

Just another thought...

 

  Patrick_Slesicki@d... wrote: 

Have just attempted opening and closing it properly with no luck. By the

way I'm working w/ Access97. Any more ideas?










Lonnie Johnson ljprodev@y... 

ProDev, Builders of MS Access Databases

Let ProDev build your next MS Access database application. 

http://www.galaxymall.com/software/PRODEV 



Get paid cash every time you receive email!

Sign up FREE at: http://www.MintMail.com/?m=975303





---------------------------------

Do You Yahoo!?

Check out Yahoo! Shopping and Yahoo! Auctionsfor all of your holiday gifts!

Can't you just delete the ldb file or is it locked for deletion as well.



____________________________________________________



John Fejsa

Systems Analyst/Computer Programmer

Hunter Centre for Health Advancement

Locked Bag 10

WALLSEND NSW 2287

Phone: (02) 49246 336 Fax: (02) 49246 209

____________________________________________________



The doors we open and close each day decide the lives we live

____________________________________________________



CONFIDENTIALITY & PRIVILEGE NOTICE

The information contained in this email message is intended for the named 

addressee only.  If you are not the intended recipient you must not copy, 

distribute, take any action reliant on, or disclose any details of the 

information in this email to any other person or organisation.  If you 

have received this email in error please notify us immediately.



>>> Patrick_Slesicki@d... 13/12/2001 6:34:40 >>>



Have just attempted opening and closing it properly with no luck. By the

way I'm working w/ Access97. Any more ideas?










This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient,
please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily
the views of Hunter Health.

Once it locks on a username, the .ldb file will claim to be in use.  The

only way to resolve this is to get the administrator to kick the user

out of the .ldb file.



-----Original Message-----

From: John Fejsa [mailto:John.Fejsa@h...]

Sent: Wednesday, December 12, 2001 4:29 PM

To: Access

Subject: [access] Re: .LDB file show user even when database is closed





Can't you just delete the ldb file or is it locked for deletion as well.



____________________________________________________



John Fejsa

Systems Analyst/Computer Programmer

Hunter Centre for Health Advancement

Locked Bag 10

WALLSEND NSW 2287

Phone: (02) 49246 336 Fax: (02) 49246 209

____________________________________________________



The doors we open and close each day decide the lives we live

____________________________________________________



CONFIDENTIALITY & PRIVILEGE NOTICE

The information contained in this email message is intended for the

named addressee only.  If you are not the intended recipient you must

not copy, distribute, take any action reliant on, or disclose any

details of the information in this email to any other person or

organisation.  If you have received this email in error please notify us

immediately.



>>> Patrick_Slesicki@d... 13/12/2001 6:34:40 >>>



Have just attempted opening and closing it properly with no luck. By the

way I'm working w/ Access97. Any more ideas?










This message is intended for the addressee named and may contain

confidential information. If you are not the intended recipient, please

delete it and notify the sender. Views expressed in this message are

those of the individual sender, and are not necessarily the views of

Hunter Health.

The directory/folder users need to have all rights except full control.

They need to be able to delete files, otherwise the lock files will persist

after the database is closed.  We jus got through dealing with the identical

problem..



Rand



-----Original Message-----

From: John Fejsa [mailto:John.Fejsa@h...]

Sent: Wednesday, December 12, 2001 3:29 PM

To: Access

Subject: [access] Re: .LDB file show user even when database is closed



Can't you just delete the ldb file or is it locked for deletion as well.



____________________________________________________



John Fejsa

Systems Analyst/Computer Programmer

Hunter Centre for Health Advancement

Locked Bag 10

WALLSEND NSW 2287

Phone: (02) 49246 336 Fax: (02) 49246 209

____________________________________________________



The doors we open and close each day decide the lives we live

____________________________________________________



CONFIDENTIALITY & PRIVILEGE NOTICE

The information contained in this email message is intended for the named

addressee only.  If you are not the intended recipient you must not copy,

distribute, take any action reliant on, or disclose any details of the

information in this email to any other person or organisation.  If you have

received this email in error please notify us immediately.



>>> Patrick_Slesicki@d... 13/12/2001 6:34:40 >>>



Have just attempted opening and closing it properly with no luck. By the

way I'm working w/ Access97. Any more ideas?










This message is intended for the addressee named and may contain

confidential information. If you are not the intended recipient, please

delete it and notify the sender. Views expressed in this message are those

of the individual sender, and are not necessarily the views of Hunter

Health.

Patrick Slesicki sent:





I've a secure database where the front end crashed on a user. Now, even

though said user does not have the database open, the .LDB file shows

she's still logged in. What's worse is that she can no longer edit certain

records (I suspect because of record locking). How can I close this

instance of the application, so my end user can use the database to edit

data?





If this happens, ensure that all users are out of the system and delete the

.LDB file - it will be re-created when the database is next accessed. If

you have trouble deleting the file, it may be that the network has placed a

lock on the file - at my site, I do not have the access rights to clear

that but the network administrator should have - then you can delete the

LDB file.



There are various (free) tools available from Micrsoft download center to

enable you to view who is in the application (LDBViewer) which could be

useful to you if you suspect there is actually somebody in the database but

can't get anybody else to admit to it. Try

http://support.microsoft.com/default.aspx and look for article q176670



*************************************************************************



This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named
recipient(s). If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return:
you should not disclose the contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an
authorised individual, nothing contained in this e-mail is intended to create binding legal obligations between us and opinions
expressed are those of the individual author.



The CIS marketing group, which is regulated for Investment Business by the Personal Investment Authority, includes:

Co-operative Insurance Society Limited Registered in England number 3615R - for life assurance and pensions

CIS Unit Managers Limited Registered in England and Wales number 2369965 (also regulated by IMRO) - for unit trusts and PEPs

CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for ISAs and investment products bearing the CIS
name

Registered offices: Miller Street, Manchester M60 0AL   Telephone  0161-832-8686   Internet  http://www.cis.co.uk   E-mail
cis@c...



CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank p.l.c., registered in England and Wales number
990937, P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of the
Bank.



CIS is a member of the General Insurance Standards Council



CIS & the CIS logo (R) Co-operative Insurance Society Limited



********************************************************************************

NOTE:  ldb file is simply a text file that you can view by opening in 

Notepad if you need to take a quick look   You don't need any special 

viewers...



____________________________________________________



John Fejsa

Systems Analyst/Computer Programmer

Hunter Centre for Health Advancement

Locked Bag 10

WALLSEND NSW 2287

Phone: (02) 49246 336 Fax: (02) 49246 209

____________________________________________________



The doors we open and close each day decide the lives we live

____________________________________________________



CONFIDENTIALITY & PRIVILEGE NOTICE

The information contained in this email message is intended for the named 

addressee only.  If you are not the intended recipient you must not copy, 

distribute, take any action reliant on, or disclose any details of the 

information in this email to any other person or organisation.  If you 

have received this email in error please notify us immediately.



>>> joe.dunn@c... 13/12/2001 20:33:22 >>>



Patrick Slesicki sent:





I've a secure database where the front end crashed on a user. Now, even

though said user does not have the database open, the .LDB file shows

she's still logged in. What's worse is that she can no longer edit certain

records (I suspect because of record locking). How can I close this

instance of the application, so my end user can use the database to edit

data?





If this happens, ensure that all users are out of the system and delete 

the

.LDB file - it will be re-created when the database is next accessed. If

you have trouble deleting the file, it may be that the network has placed 

a

lock on the file - at my site, I do not have the access rights to clear

that but the network administrator should have - then you can delete the

LDB file.



There are various (free) tools available from Micrsoft download center to

enable you to view who is in the application (LDBViewer) which could be

useful to you if you suspect there is actually somebody in the database 

but

can't get anybody else to admit to it. Try

http://support.microsoft.com/default.aspx and look for article q176670



*************************************************************************



This e-mail may contain confidential information or be privileged. It is 

intended to be read and used only by the named recipient(s). If you are 

not the intended recipient(s) please notify us immediately so that we can 

make arrangements for its return: you should not disclose the contents of 

this e-mail to any other person, or take any copies. Unless stated 

otherwise by an authorised individual, nothing contained in this e-mail is 

intended to create binding legal obligations between us and opinions 

expressed are those of the individual author.



The CIS marketing group, which is regulated for Investment Business by the 

Personal Investment Authority, includes:

Co-operative Insurance Society Limited Registered in England number 3615R 

- for life assurance and pensions

CIS Unit Managers Limited Registered in England and Wales number 2369965 

(also regulated by IMRO) - for unit trusts and PEPs

CIS Policyholder Services Limited Registered in England and Wales number 

3390839 - for ISAs and investment products bearing the CIS name

Registered offices: Miller Street, Manchester M60 0AL   Telephone  

0161-832-8686   Internet  http://www.cis.co.uk   E-mail cis@c...



CIS Deposit and Instant Access Savings Accounts are held with The 

Co-operative Bank p.l.c., registered in England and Wales number 990937, 

P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by 

CIS Policyholder Services Limited as agent of the Bank.



CIS is a member of the General Insurance Standards Council



CIS & the CIS logo (R) Co-operative Insurance Society Limited



***************************************************************************

*****








This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient,
please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily
the views of Hunter Health.