M
Matthew O''''Riordan
Hi
I have had a persistent problem since I have upgraded to Access 2007 which I
have been unable to resolve in code or through any level of debugging.
However, if I open the same Access Project file now in Access 2003 the
application works which indicates to me that Access 2007 has a bug of some
sort with Extended Properties.
Whenever I choose a drop down value for a new record in a sub-form (linked
by Primary Key) I get an error as follows:
[Accesss Application Name] can't find the object 'SELECT &,
sql_variant_property(value, 'basetype') as type FROM
::fn_listextendedproperty(N'MS_WSSTemplateID',N'user',N'LemonAccessApp',N'table',N'[Table name used by parent form],NULL,NULL)'
The master form is a relatively simple form in Data View, with a sub-form
control containing another form which is in Data View. I have tried changing
the sub-form to Form View and this makes no difference. Strangely there is
no code interfering in this i.e. there are no onChange events etc. so this is
a pure Access form issue.
I have searched the web for any references to MS_WSSTemplateID and cannot
find anything. It appears that for some reason access is trying to retrieve
extended properties from the table of the master form which do not exist. If
run that SQL in Query Analyzer I get an empty result table returned.
I would appreciate any advice on how to get around this problem or what may
be causing it. This has had me stumped for weeks now and is making me think
about downgrading everyone back to 2003!
Thanks.
--
Regards,
Matthew O'Riordan
Lemon Foundation
http://www.lemonfoundation.com/
I have had a persistent problem since I have upgraded to Access 2007 which I
have been unable to resolve in code or through any level of debugging.
However, if I open the same Access Project file now in Access 2003 the
application works which indicates to me that Access 2007 has a bug of some
sort with Extended Properties.
Whenever I choose a drop down value for a new record in a sub-form (linked
by Primary Key) I get an error as follows:
[Accesss Application Name] can't find the object 'SELECT &,
sql_variant_property(value, 'basetype') as type FROM
::fn_listextendedproperty(N'MS_WSSTemplateID',N'user',N'LemonAccessApp',N'table',N'[Table name used by parent form],NULL,NULL)'
The master form is a relatively simple form in Data View, with a sub-form
control containing another form which is in Data View. I have tried changing
the sub-form to Form View and this makes no difference. Strangely there is
no code interfering in this i.e. there are no onChange events etc. so this is
a pure Access form issue.
I have searched the web for any references to MS_WSSTemplateID and cannot
find anything. It appears that for some reason access is trying to retrieve
extended properties from the table of the master form which do not exist. If
run that SQL in Query Analyzer I get an empty result table returned.
I would appreciate any advice on how to get around this problem or what may
be causing it. This has had me stumped for weeks now and is making me think
about downgrading everyone back to 2003!
Thanks.
--
Regards,
Matthew O'Riordan
Lemon Foundation
http://www.lemonfoundation.com/