compact and repair on a network drive

C

cman

I have an Access 2003 database that I compact and repair regularly. The
problem is now when I perform that action on the network drive I get a
unrecognized database format and a permissions error followed by a message
that tells me that the database is partially converted. In the process of
this it decreases the size of the file by half its original size. I have
checked permissions on the drive and I have full permissions. The really
crazy thing is that when I move this 124MB file to my C: drive I can perform
the function flawlessly. Any help is greatly appreciated.
 
R

Roger Carlson

I never compact a large database on a network drive. I always copy it to my
workstation, compact it and then copy it back up. To keep people from
modifying the data, I rename the file on the Network while I am doing this.

I do this for 3 reasons: 1) compacting works much faster on the workstation
since the bus on the workstation is much faster than a LAN connection and 2)
dragging that much data back and forth across a network connection increases
the risk of data corruption. When the database is corrupted during a
Compact, the database is often irrecoverable, and 3) if I compact a copy of
the database on my workstation, if anything goes wrong during the compact, I
still have the network copy as a backup.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
T

Tony Toews

cman said:
I have an Access 2003 database that I compact and repair regularly. The
problem is now when I perform that action on the network drive I get a
unrecognized database format and a permissions error followed by a message
that tells me that the database is partially converted. In the process of
this it decreases the size of the file by half its original size. I have
checked permissions on the drive and I have full permissions. The really
crazy thing is that when I move this 124MB file to my C: drive I can perform
the function flawlessly.
Click to expand...

Very interesting. I have regularly compacted 300 Mb MDBs on a server
without any problems.

What type of server? Windows or Netware or other? I was going to
suggest that the record locks were too low on the server but
compacting shouldn't be using any record locks as it has exclusive
access to the MDB.

Have you tried importing the MDB to a new MDB and the try compacting
that? There may be some wield corruption present. Use the sysrels
utility at the following location to copy the table relationships
layout window
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=12#12
Or use Save Restore Modify Relationship Window at
http://www.lebans.com/saverelationshipview.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top