DbHd
Programmer
- Dec 20, 2004
- 39
I had 1 Access db open, about 6 reports open in dev view, and the VBA window. After working for a few hours I saw an error box stating I had run out of handles and to increase the number of handles in the registry.
I thought just another error msg and kept on working. When I closed all open objects I saw that 23 reports are gone. Their names still show in msobjects but no reports.
I'm running XP Pro SP2 with 1GB RAM & Office 3000 SP2. This db is set as a Access 2000 db. It has 9 linked tables with little activity and I'm the only user.
1. What is the handles error and how do I prevent it? I recall handle issues in the 16 bit apps but not now.
2. I've never had much luck recovering lost or damaged objects, but is there a way?
3. How do I get the names or of sysobjects?
Thanks for your help (again).
Earle
I thought just another error msg and kept on working. When I closed all open objects I saw that 23 reports are gone. Their names still show in msobjects but no reports.
I'm running XP Pro SP2 with 1GB RAM & Office 3000 SP2. This db is set as a Access 2000 db. It has 9 linked tables with little activity and I'm the only user.
1. What is the handles error and how do I prevent it? I recall handle issues in the 16 bit apps but not now.
2. I've never had much luck recovering lost or damaged objects, but is there a way?
3. How do I get the names or of sysobjects?
Thanks for your help (again).
Earle
