[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