Please refer to https://www.pcreview.co.uk/forums/thread-3048994.php.
I am facing similar situation and have not been able to find a solution for this.
Recap: We upgraded from Access 2003 to Access 2007 for our front end which runs runs on Windows XPP service pack 2. Our database is on MSSQL Server 2005 on windows server std 2003.
The application works fine.
The issue is that as soon as we try to modify the code by switching from "Form View" to "Design View", we observe high CPU utilisation. On running SQL profiler we have found that there is flood of queries. Sample of them is provided here for your information:
Sample of queries from profiler
SELECT *, sql_variant_property(value, 'basetype') AS type FROM ::fn_listextendedproperty(N'MS_Description',N'user',N'sys',N'procedure',N'sp_MSenumchanges',NULL,NULL
SELECT *, sql_variant_property(value, 'basetype') AS type FROM ::fn_listextendedproperty(N'MS_Description',N'user',N'sys',N'procedure',N'sp_MSenumchanges_belongtopartition',NULL,NULL
SELECT *, sql_variant_property(value, 'basetype') AS type FROM ::fn_listextendedproperty(N'MS_Description',N'user',N'sys',N'procedure',N'sp_MSenum_snapshot_sd',NULL,NULL
SELECT *, sql_variant_property(value, 'basetype') AS type FROM ::fn_listextendedproperty(N'MS_Description',N'user',N'sys',N'procedure',N'sp_MSenum_merge_sd',NULL,NULL)
These queries do not stop even after we come out of "Design View". Only when we close our application does this flood stop.
Action Taken So Far:
1. DBCC checks done and found no errors
2. Deleted all extended properties from all application related tables. This has not helped, as suggested by some article on the internet.
Please provide suggestion / advise to resolve this issue.
I am facing similar situation and have not been able to find a solution for this.
Recap: We upgraded from Access 2003 to Access 2007 for our front end which runs runs on Windows XPP service pack 2. Our database is on MSSQL Server 2005 on windows server std 2003.
The application works fine.
The issue is that as soon as we try to modify the code by switching from "Form View" to "Design View", we observe high CPU utilisation. On running SQL profiler we have found that there is flood of queries. Sample of them is provided here for your information:
Sample of queries from profiler
SELECT *, sql_variant_property(value, 'basetype') AS type FROM ::fn_listextendedproperty(N'MS_Description',N'user',N'sys',N'procedure',N'sp_MSenumchanges',NULL,NULL
SELECT *, sql_variant_property(value, 'basetype') AS type FROM ::fn_listextendedproperty(N'MS_Description',N'user',N'sys',N'procedure',N'sp_MSenumchanges_belongtopartition',NULL,NULL
SELECT *, sql_variant_property(value, 'basetype') AS type FROM ::fn_listextendedproperty(N'MS_Description',N'user',N'sys',N'procedure',N'sp_MSenum_snapshot_sd',NULL,NULL
SELECT *, sql_variant_property(value, 'basetype') AS type FROM ::fn_listextendedproperty(N'MS_Description',N'user',N'sys',N'procedure',N'sp_MSenum_merge_sd',NULL,NULL)
These queries do not stop even after we come out of "Design View". Only when we close our application does this flood stop.
Action Taken So Far:
1. DBCC checks done and found no errors
2. Deleted all extended properties from all application related tables. This has not helped, as suggested by some article on the internet.
Please provide suggestion / advise to resolve this issue.