I'm having a problem that I can't solve myself. I think this is a bug, but I might try to explain it to you. First of all, I checked and my softwares are up to date.
I'm using .adp project in Access 2007 (but the bug also appear when using Access 2003). So I'm connecting to SQL Server 2008 SP1 from my Access adp project. It seems that Access is doing some internal query to SQL Server 2008 that slows up EVERY query I do. I've been watching onto the SSMS Activity Monitor and it shows this query :
select v.name, schema_name(v.schema_id), v.type, cast(case when v.is_ms_shipped = 1 then 1when (select major_id from sys.extended_properties where major_id = v.object_id and minor_id = 0 and class = 1 and name = N'microsoft_database_tools_support')is not null then 1 else 0 end as bit),ObjectProperty(v.object_id, N'IsSchemaBound') from sys.all_objects AS v where v.type = N'V' and permissions(v.object_id) & 4096 <> 0
This query runs for about 1 second. And it runs for every action I do on Access. The problem is only if you're a NOT sysadmin user on the database and it seems that this is the "permissions()" function that slows up.
I've been searching around the web for hours and hours and I can't figur
View Complete Post