Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What causes .ldb to stay open on server? 1

Status
Not open for further replies.
Tomadams

Tomadams

Programmer
Jun 26, 2001
141
US
I can not get my .ldb to close. I am running A2K on Windows2000 server. I can only get the .ldb to shut down by rebooting the server. Then after the first start of the db, it is there again. all users have full permissions.

Hurry, I don't have much hair left!!!!!!!
 
Sort by date Sort by votes
the reason i thought the idb file was created is when a user enters the db, then when the no one is in the database then the idb file will disappear.

Are you sure everybody is out of the database.

If you open the idb through Notepad, then you can tell you is in the database, if thats any help...
 
Upvote 0 Downvote
Make sure that the people who are using the database have delete permissions on the folder.
The other reason the file may be left behind is users crashing out of your database, rather than exiting normally. Ask if anyone is having to do this. It's heading for corruption if it carries on.

Ben

----------------------------------------------
Ben O'Hara "Where are all the stupid people from...
...And how'd they get so dumb?"
rockband.gif
NoFX-The Decline
----------------------------------------------
Want to get great answers to your Tek-Tips questions? Have a
 
Upvote 0 Downvote
Deleting the .ldb is not the cure. It will stay open the next time someone opens the file. Right now I have 10 users who cannot open the application.

Need more power on this issue!
 
Upvote 0 Downvote
Have you checked out my suggestions?
Can you identify who is leaving the ldb behind? There is a db available at that may help work out who is causing the problems. Try that and get back to us.

B

----------------------------------------------
Ben O'Hara "Where are all the stupid people from...
...And how'd they get so dumb?"
rockband.gif
NoFX-The Decline
----------------------------------------------
Want to get great answers to your Tek-Tips questions? Have a
 
Upvote 0 Downvote
It will stay open if I am the only user. Or any one of the work stations will leave it opne. All usres have delete permissions. I have discussed the correct way to close down the database with each user. Even explaining it in terms like, "if you don't use the exit button, that is like going down the highway and putting your car in park. It wrecks thins!" about that time they got the idea.

Another issue that may complicate the problem is that each evening I upload the access to SQL Server on another server. I don't know of any negative ramnifications of that , but right now I am confused.

thanks for all you rhelp so far.
Tom
 
Upvote 0 Downvote
How are you uploading to SQL Server?

----------------------------------------------
Ben O'Hara "Where are all the stupid people from...
...And how'd they get so dumb?"
rockband.gif
NoFX-The Decline
----------------------------------------------
Want to get great answers to your Tek-Tips questions? Have a
 
Upvote 0 Downvote
Tom,

Here's a link that might help you. Add the form to your database or use the download db as a standalone. When you open the form you can point to the DB in question and it will shown you who has a connection to the DB and whether or not it is questionable. The last part may help solve your problem as it will show any user who has crashed out.

Basically, there are two reasons for the LDB file to be left in the directory. 1)Last user does not have delete permissions. 2)Someone (or some application) crashed out and left a connection open to the DB.

The first condition is not too difficult to resolve and will not require you to reboot the server to delete the file. If rebooting is required and you are sure ALL users are out of the database, then a connection has been left open. But, you shouldn't leave it at that. A connection left open could be because the computer that crashed out of your app. is still on-line with the network. If you cannot manually delete LDB file, first verify ALL workstations that have accessed the DB are off-line (shut down). If not, shut them down and try deleting the LDB. If all are shutdown and you still cannot delete the LDB, then the server file system has a lock on the file.

You mention running an update to move data to SQL Server. I would assume this is done on a server - possibly a nightly scheduled process? View the LDB with the above viewer. Is the username used by the update process there? Sometimes when dealing with servers - especially if you yourself are not the server administrator - some other scheduled process is the culprit. Perhaps even network maintenance? Look for something that might occur when your nightly update process is running.
 
Upvote 0 Downvote
I don't think the user leaving it open is the issue. I can reboot the server, logon myself, then close the app normally via application.quit. Perusing windows explorer shows that the ldb still exists. I can then delete the ldb and it will reappear.

Microsoft says the error is caused by opening a form that has a control referencing a form on a sub form. And hat is the case here. I have technicians doing quality analysis. They must tell me what product line and brand they are analysizing and then I open the appropriate subform. Microsoft says it can be fixed by loading SR-1a on each usrs version of access.

I am going to try that this morning. The user site is 30 miles away.

I'll let you know if this works, Thanks for all your help and concerns
 
Upvote 0 Downvote
That was it. The initial screen for technicians was a complex form with controls in the header referencing controls in the detail section. I loaded SR-1a and everything works great. Thanks for all the help
Tom
 
Upvote 0 Downvote
Have a star for solving it!
I've never used anything other than fully patched systems, so I've never come across it.

Ben

----------------------------------------------
Ben O'Hara "Where are all the stupid people from...
...And how'd they get so dumb?"
rockband.gif
NoFX-The Decline
----------------------------------------------
Want to get great answers to your Tek-Tips questions? Have a look at F
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Question
Converting from 32bit to 64 bit. After converting, database takes significantly longer to open 1
Replies
14
Views
814
dhookom
dhookom
Moss100
  • Locked
  • Question
Open filtered for and set cursor at particular record
Replies
1
Views
586
Moss100
Moss100
hermanlaksko
  • Question
Convert PDF file to text
Replies
6
Views
335
hermanlaksko
hermanlaksko
V
  • Locked
  • Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
581
strongm
strongm
TheAceMan1
  • Locked
  • Question
Delete from listi n XL open tab with VBA
Replies
2
Views
489
TheAceMan1
TheAceMan1

Part and Inventory Search

Sponsor

Back
Top