Extended properties SQL Server 2005

F

Francesco

Hi,
Can I read and write the extended properties with Access?
If it’s possible is better create a project (ADP) or a classic MDB?

When I try with this query in the query panel (in a MDB)

SELECT objtype, objname, name, value
FROM fn_listextendedproperty
( NULL, 'schema', 'Person', 'table', default, NULL, NULL)

I have this error message: The size of a field is too long

If I try with an ADP, when I ask a new query in design view, I have a
message for some problems between the Access version (2003) and SQL Server
version (2005) and I can’t save and run the query.

Tanks.
 
Top