Question about using Access97 with VB6pro

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

It does run quicker in a single user environment but if you have the Access database opened by 5-10 users at once, you are going to run into performance problems and database corruption.. I started doing this a couple of months ago and noticed these problems.

PS. This does work pretty well if you are using SQL Server as the back-end!