[AccessD] ldb

Two things.  If compacting the backend is making it smaller, then you
should look at what you are doing with data in the backend.

A database does not automatically free up space when you delete data.
There are several practices that can reduce the amount of 'bloat' to a
database (growth that goes away when you compact the database). One
biggie is if you are using 'temp' tables (where you are writing data
that gets over written frequently), move such processes to the front
end.

The second thing, is your IT folks don't need to reboot the server.
Just use Computer Management and 'close' all the open file connections
to the Backend .mdb.

Drew



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Catherine
Blansett
Sent: Wednesday, April 09, 2008 7:30 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] ldb

Hi all,

 

I am doing some development work on a research project at a VA medical
center. I have a portion of one drive ("U-drive") and access to a common
drive ("K-drive") for research purposes. I developed a front-end
database
and a back-end database on the "U" drive and put the back-end on the
k-drive. They function as they should. However, while I was developing,
every time I compacted the databases a copy was created and named
db1.....etc.
The original version of the compacted db grew. So, I would rename the
new
version and delete the old (a bit tiring). When I work with these
databases
on my home computer (sans data of course) it works the way it should.
This
situation at work would be bothersome, but doable, if it weren't for the
fact that, at some time (not sure when, but generally, others are
complaining of a slow connection so suspect the system gets bogged
down), it
also creates a locked file that does not allow the databases to be
compacted
- "the db is being used by another", and then gives my ID number. Once
these
databases get locked, it becomes impossible to compact/rename/delete the
databases and to change the name of excel files. 

 

So far, IT is a bit confused. They have rebooted the U drive and this
released the locks and I was able compact, delete, or whatever. But
then, in
a couple of days, I am back to the same situation again. The databases
still
works just fine, but they are getting much too big.

 

I have heard of this problem, but this is the first time I have
encountered
it. Any help would be most welcomed.

 

Thanks in advance

 

CB

 


No virus found in this outgoing message.
Checked by AVG. 
Version: 7.5.519 / Virus Database: 269.22.9/1365 - Release Date:
4/8/2008
7:30 AM
 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.