Error Message when creating new records on a subform

[Guest]

When I create a new record on a subform I get the following error message:

(application name) can't find the object 'select *,
sql_variant_property(value, 'basetype') aS type from
::fn_listextendedproperty(N'MS_WSSTemplateID', N'user',N'brad', N'table',
N'StoreMaster',NULL,NULL)'

Anyone have any clues? I cant figure it out! I'm logged in as user brad.
But I also tried logging in as sa. when I log in as sa it replaces brad with
dbo.

Anyone have any clues? It seems to have started when I moved to SQL 2005 or
when I moved it to Access 2007.

This issue has also been reported at:

http://www.eggheadcafe.com/software/aspnet/29727915/access-2007-problem-with.aspx
an
http://groups.google.com/group/micr...read/thread/ee3cecc4e25e73c6/e092afbe6db63f24

Thanks,

Bradley

 

[Erik]

Hi,

I too have the same problem when creating a new record in a sub form in
Access 2007 when opening an Access 2003 ADP project (which works fine in
2003). My database backend is SQL 2000 so no 2005 involved for me.

I also searched the net and found the articles you link to. But no solution.
So let's hope someone else has some ideas.

/ Erik

 

[Erik]

Hello again,

So nobody has any solutions or ideas for this problem?

I have searched the net again now for any solutions, but still I can't find
anything. As Bradley noted below there seem to be many people who have
experienced this issue...

/ Erik

 

[Guest]

Hi Erik,

To date I haven't found a solution. I've been in contact with a few others
who have this exact same issue and no go with them either.

I really believe its in the code somewhere.

Bradley