mdb load time...

[Gary B]

We use Jet and ADO to connect to the mdb file from an outside application.

We recently started adding Queries(Views) to the database in order to make
our queries more efficient.

Now, there is a lag when the application connects to the data, and I do not
even open any of those Queries when connecting.

Even when I add more Queries, the size of the mdb grows (even after a
rebuild).
I thought only SQL text is being stored, is that not the case?

Does anyone know why?

 

[[MVP] S.Clark]

I don't know why it would slow down, but adding any object to an mdb will
cause an mdb to bloat. Repair and compact and it will reduce it's size.

FWIW, mdb's don't have views, only queries. Are you sure it's an mdb, and
not an ADP?


--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting