CRASH

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i get a crash in ADP that I can duplicate it.

I have a parent-child relationship that I am building a catalog for--
basically keeping track of what children are how many generations old; etc

Here is my SQL:
SELECT LEVEL4.*
FROM dbo.MRS_RPTMENU LEVEL1 INNER JOIN
dbo.MRS_RPTMENU LEVEL2 ON LEVEL1.ID = LEVEL2.PARENTID
INNER JOIN
dbo.MRS_RPTMENU LEVEL3 ON LEVEL2.ID = LEVEL3.PARENTID
INNER JOIN
dbo.MRS_RPTMENU LEVEL4 ON LEVEL3.ID = LEVEL4.PARENTID
WHERE (LEVEL1.PARENTID = 0)

I am editing this in design view,
i go down to add a field, called L1,

I accidently typed this in the 'Column' field instead of the 'alias' field
(in design view); and it crashes Access 2002 for me.

Obviously, it is looking for a field named L1, and it can't find it-- but it
shouldn't crash

Please fix this, I do not accept crashes lightly; as I always lose data when
this happens.

Here are the fields from this table:

ID
NAME
NAME_HTML
DESCRIPTION
DESCRIPTION_HTML
PARENTID
CHILDRENCOUNT
ZERO


And just for the record, 'ZERO' is a calculated field, assigned to a
constant. I do this in order to create a 'FactLess Fact Table'.

-Aaron
 
i get a crash in ADP that I can duplicate it.

I have a parent-child relationship that I am building a catalog for--
basically keeping track of what children are how many generations old; etc

Here is my SQL:
SELECT LEVEL4.*
FROM dbo.MRS_RPTMENU LEVEL1 INNER JOIN
dbo.MRS_RPTMENU LEVEL2 ON LEVEL1.ID = LEVEL2.PARENTID
INNER JOIN
dbo.MRS_RPTMENU LEVEL3 ON LEVEL2.ID = LEVEL3.PARENTID
INNER JOIN
dbo.MRS_RPTMENU LEVEL4 ON LEVEL3.ID = LEVEL4.PARENTID
WHERE (LEVEL1.PARENTID = 0)

I am editing this in design view,
i go down to add a field, called L1,

I accidently typed this in the 'Column' field instead of the 'alias' field
(in design view); and it crashes Access 2002 for me.

Obviously, it is looking for a field named L1, and it can't find it-- but it
shouldn't crash

Please fix this, I do not accept crashes lightly; as I always lose data when
this happens.

Here are the fields from this table:

ID
NAME
NAME_HTML
DESCRIPTION
DESCRIPTION_HTML
PARENTID
CHILDRENCOUNT
ZERO


And just for the record, 'ZERO' is a calculated field, assigned to a
constant. I do this in order to create a 'FactLess Fact Table'.

-Aaron
Click to expand...

huh?
 
FactLess Fact tables = an OLAP cube with a fact table based on a dimension.

Catalog Parent Child = 'I get all of the ancestors and children of a
standard level; and i store this in a table-- so that I don't have to always
do loops and crazy SQL'

Basically, i dont care what the SQL Statement says. I don't want excuses, I
don't want advice on how to do it differently.

Access crashed; and I want Microsoft to fix it.

Microsoft has been abusing ADP developers for many years now; and I am going
to raise a stink until they start making this product more polished.

-Aaron
 
Faulting application msaccess.exe, version 10.0.6501.0, faulting module
vdt70.dll, version 7.0.9064.9112, fault address 0x002326b2.
 
I think that I didn't have SP3 installed. I swear i installed it.. i just
can't figure out how to get a secure copy of MSDE running
 
Back
Top