Strange error

A

Atlas

Access 2003 + MS SQL Server 2000 + adp project (ADO)

Dont't know why, sometimes in a form + subform, when editing data on a new
record in the form I get the following error:

myprojectname can't fine the object 'SHAP (SHAPE RS_456 AS rsLevel0 COMPUTE
rsLevel0, Sum(rsLevel0.[Avere]) AS C=, SUm(rsLevel0.[Dare]) AS C1) AS
RS_457.

* You misspelled the object name. check for missing underscores (_) or other
punctuation............(CUT)
* You tried to open a linked table, but the file containing the table isn't
on the path .......(CUT).

Lately decompiling the project helped to avoid the rpblem, but now it looks
like it doesn't help any more.

I'm terrified by these woing beheaviour.......

Any help really appreciated
 
A

Atlas

Atlas said:
Access 2003 + MS SQL Server 2000 + adp project (ADO)

Dont't know why, sometimes in a form + subform, when editing data on a new
record in the form I get the following error:

myprojectname can't fine the object 'SHAP (SHAPE RS_456 AS rsLevel0
COMPUTE rsLevel0, Sum(rsLevel0.[Avere]) AS C=, SUm(rsLevel0.[Dare]) AS C1)
AS RS_457.

* You misspelled the object name. check for missing underscores (_) or
other punctuation............(CUT)
* You tried to open a linked table, but the file containing the table
isn't on the path .......(CUT).

Lately decompiling the project helped to avoid the rpblem, but now it
looks like it doesn't help any more.

I'm terrified by these woing beheaviour.......

Any help really appreciated


Still stuck with this problem....any help?

Thanks
 
S

Sylvain Lafontaine

Never seen this error before. Are you using the SHAPE command when opening
your recordsets?

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC


Atlas said:
Atlas said:
Access 2003 + MS SQL Server 2000 + adp project (ADO)

Dont't know why, sometimes in a form + subform, when editing data on a
new record in the form I get the following error:

myprojectname can't fine the object 'SHAP (SHAPE RS_456 AS rsLevel0
COMPUTE rsLevel0, Sum(rsLevel0.[Avere]) AS C=, SUm(rsLevel0.[Dare]) AS
C1) AS RS_457.

* You misspelled the object name. check for missing underscores (_) or
other punctuation............(CUT)
* You tried to open a linked table, but the file containing the table
isn't on the path .......(CUT).

Lately decompiling the project helped to avoid the rpblem, but now it
looks like it doesn't help any more.

I'm terrified by these woing beheaviour.......

Any help really appreciated


Still stuck with this problem....any help?

Thanks
 
A

Atlas

Sylvain Lafontaine said:
Never seen this error before. Are you using the SHAPE command when
opening your recordsets?

Dunno really; I'm simply using a bound form + subform; the recordsource of
the mainform is given by a VBA-built SELECT statement;

What I have noticed is that when making the SELECT simplier, the problem
disappears.....
 
À

ÀÒÁ

Atlas said:
Atlas said:
Access 2003 + MS SQL Server 2000 + adp project (ADO)

Dont't know why, sometimes in a form + subform, when editing data on a new
record in the form I get the following error:

myprojectname can't fine the object 'SHAP (SHAPE RS_456 AS rsLevel0
COMPUTE rsLevel0, Sum(rsLevel0.[Avere]) AS C=, SUm(rsLevel0.[Dare]) AS C1)
AS RS_457.

* You misspelled the object name. check for missing underscores (_) or
other punctuation............(CUT)
* You tried to open a linked table, but the file containing the table
isn't on the path .......(CUT).

Lately decompiling the project helped to avoid the rpblem, but now it
looks like it doesn't help any more.

I'm terrified by these woing beheaviour.......

Any help really appreciated


Still stuck with this problem....any help?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top