Hi

I use DAO in code to query some Access97 databases.

There are many parts of my program that get data from different tables and databases at different times.

I always clode the database connection once my SQL has been run.

I was wondering if the program would function quicker, if I made a public database variable for each part of the program that is open from when the program is first run, until it is closed.

Note: my program runs across a 10Mbit/s network and has about 50,000 records.

Also, does compressing the database make it quicker?

Thanks