|
|
|
#1
10-23-2008, 03:43 PM
|
|||
|
|||
Slow Access 2007 Project
My Access 2007 project is making thousands of SQL calls to the SQL Server 2000 database. This was once a Access 2003 project. Here is the call:
SELECT *, sql_variant_property(value, 'basetype') AS type FROM ::fn_listextendedproperty(N'MS_Description',N'user',N'dbo',N'table',N'Activ eBonds21',NULL,NULL) This is slowing Access down, and making the application unusable. Can you help? 
|
|
| Bookmarks |
| Tags |
| access 2007, extended properties |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| converting from Access 2003 to Access 2007 | LawrenceLau | Access | 6 | 11-20-2008 12:53 PM |
| Access Novice Taking On Large Project - Need Guidance | gtangjr | Database Design | 1 | 04-04-2008 06:41 PM |
| Security in Access 2007(Restricting changes to tables) | nybanshee | Security | 0 | 03-26-2008 06:46 PM |
| very slow when connect to access 2000 | pureland | Access | 0 | 10-23-2007 03:42 AM |
| Slow Access Loading time | alexstoker | Access | 3 | 02-05-2006 05:55 AM |
Linear Mode
