Greggs
greggs at msn.com
Mon Dec 8 11:07:42 CST 2003
yeah -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark Boyd Sent: Monday, December 08, 2003 10:39 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Splitting 2002 data makes reports lock up Charlotte - Where do you turn off subdatasheets? I'm curious if this will resolve a linked issue I'm having. Thanks, Mark Boyd Sr. Systems Analyst McBee Associates, Inc -----Original Message----- From: Charlotte Foust [mailto:cfoust at infostatsystems.com] Sent: Monday, December 08, 2003 11:28 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Splitting 2002 data makes reports lock up Did you remember to turn off subdatasheets on all those tables after you split the database? You probably need to do it on both front and back end. That should make a difference in performance with linked tables. Charlotte Foust -----Original Message----- From: Greggs [mailto:greggs at msn.com] Sent: Monday, December 08, 2003 7:38 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Splitting 2002 data makes reports lock up I took a database designed by another individual and split it into a FE and a BE. Essentially I took all the tables except switchboard, moved them to a new database and linked them back in. Now some of the larger reports lock up the system. These reports take seconds to run in the old database even though they are a couple hundred pages. The symptoms are the same on all systems. Any ideas? Gregg Steinbrenner _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com