Solved

Clearing Treeview Crashes Access nastily

Posted on 2004-09-13
2
279 Views
Last Modified: 2010-05-18
heya

When I try and clear my treeView control with oTVResults.Nodes.Clear Access just crashes, I get no error message, but it tells me that I need to backup and repair my database.

I'm using the TreeView control on a tabbed page within a form (not sure if the tabbed thing is part of the reason)

it's a relatively urgent issue so eh... any help would be appreciated

I'm using office 2003 on windows xp and I haven't done SP2 yet

thanks
0
Comment
Question by:K_man
2 Comments
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 500 total points
ID: 12044217
Have you tried decompiling your database? (Do this on a copy!) - create a shortcut with this command line:

"<path to access>" "<path to your database>" /decompile
0
 

Expert Comment

by:peteredm
ID: 21005252
I'm having this problem as well, I have tried the accepted solution of creating a decompile shortcut and then running this but still crashes out.

shortcut is: "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" \\Rbhfile9\infectioncontrol\ESBL\DB\Development\ESBL_2008-02-28.mdb /decompile

Any thoughts appretiated. Thanks
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question