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.
 

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