I have written various databases for work here which have been added to 
daily for the last 5 years, they are now really starting to struggle. I 
use normal Access mdb front end, SQL2000 back end. 10 databases, the 
biggest of these is about 30 tables, largest table 50000 records. Each 
Front End has about 200+ queries, 50 forms, 200 reports. I tried before 
to rewrite all the databases as Access Projects but it was going to take 
months and I don't have the time, and not sure it would make that much 
difference to performance. Is there an alternative to Access Project 
using normal Access, without it opening all the ODBC connections whenever 
anyone opens the database?
Or is there some general things I can do to increase performance of these 
databases, the records probably double every 10 months or so, so if 
struggling now it's not going to last for long unless redesign.
thanks

> I have written various databases for work here which have been added to 
d> aily for the last 5 years, they are now really starting to struggle. I 
u> se normal Access mdb front end, SQL2000 back end. 10 databases, the 
b> iggest of these is about 30 tables, largest table 50000 records. Each 
F> ront End has about 200+ queries, 50 forms, 200 reports. I tried before 
t> o rewrite all the databases as Access Projects but it was going to take 
m> onths and I don't have the time, and not sure it would make that much 
d> ifference to performance. Is there an alternative to Access Project 
u> sing normal Access, without it opening all the ODBC connections 
whenever 
a> nyone opens the database?
O> r is there some general things I can do to increase performance of 
these 
d> atabases, the records probably double every 10 months or so, so if 
s> truggling now it's not going to last for long unless redesign.
t> hanks

You can try 'Pass-Through Queries' as they are executed on the SQL Server
and not the client's MDB.

Cheers,
Andrew

-----Original Message-----
From: Vladimiro Cerni [mailto:vladimiro.cerni@t...]
Sent: Wednesday, 19 February 2003 1:10 AM
To: Access
Subject: [access] Re: Access Databases grinding to a halt - help please


> I have written various databases for work here which have been added to 
d> aily for the last 5 years, they are now really starting to struggle. I 
u> se normal Access mdb front end, SQL2000 back end. 10 databases, the 
b> iggest of these is about 30 tables, largest table 50000 records. Each 
F> ront End has about 200+ queries, 50 forms, 200 reports. I tried before 
t> o rewrite all the databases as Access Projects but it was going to take 
m> onths and I don't have the time, and not sure it would make that much 
d> ifference to performance. Is there an alternative to Access Project 
u> sing normal Access, without it opening all the ODBC connections 
whenever 
a> nyone opens the database?
O> r is there some general things I can do to increase performance of 
these 
d> atabases, the records probably double every 10 months or so, so if 
s> truggling now it's not going to last for long unless redesign.
t> hanks

IMPORTANT - PLEASE READ ******************** 
This email and any files transmitted with it are confidential and may 
contain information protected by law from disclosure. 
If you have received this message in error, please notify the sender 
immediately and delete this email from your system. 
No warranty is given that this email or files, if attached to this 
email, are free from computer viruses or other defects. They 
are provided on the basis the user assumes all responsibility for 
loss, damage or consequence resulting directly or indirectly from 
their use, whether caused by the negligence of the sender or not.