BUG! Compact and Repair network drive sp3 db1 db2 db3...

[John M]

Microsoft needs to fix this bug!
When compacting a DB on a network drive the original file stays and it
creates the compacted one with the name db1. For whatever reason it does not
delete the old file and rename the new one.
On a high speed corporate network
Full permissions on the folder and files
No one else has access to the folder

This is a bug ever since SP3 for office. Fix it fix it fix it
Better yet maybe I'll petition my corporation to go with an open source
application instead. I'm so sick of microsoft not dealing with bugs that
they have created. We pay big money for their products and they leave us
hanging all the time.

 

[Roger Carlson]

Or you could create your own compact routine, creating a meaningfully named
backup in the process.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "CompactDatabase.mdb" which illustrates how to do this. Find
it here: http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=377

(Open Source applications don't have bugs?)

--
--Roger Carlson
MS Access MVP
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

 

[John W. Vinson]

Microsoft needs to fix this bug!
When compacting a DB on a network drive the original file stays and it
creates the compacted one with the name db1. For whatever reason it does not
delete the old file and rename the new one.
On a high speed corporate network
Full permissions on the folder and files
No one else has access to the folder

This is a bug ever since SP3 for office. Fix it fix it fix it
Better yet maybe I'll petition my corporation to go with an open source
application instead. I'm so sick of microsoft not dealing with bugs that
they have created. We pay big money for their products and they leave us
hanging all the time.

Double and triplecheck the user's permissions on the folder. The way compact
works is to make a copy of the database (named db1, db2 etc.), delete the old
database, and rename the dbX.mdb to the database's old name.

If the user *executing the compact* doesn't have Delete and Modify permissions
on the folder, the renaming and deleting will fail.

I (and lots of other folks) have SP3 databases which do not have this problem.

Note that this newsgroup is staffed by volunteers; Microsoft personnel don't
routinely monitor it, and it's not a good way to report bugs. If you're sure
it's a bug, you may want to open a maintenance incident with Microsoft tech
support.

 

[John M]

Roger,
Thanks for your suggestion. To me this is a big deal since I have about 30
DBs doing reporting. My post was really to get under their skin to actually
do something about it.

Yes of course open source has bugs but the response is quicker to the fix
and they would understand the importance.

Thanks again for taking the time.
John

 

[John M]

John,
Opening a maintenance incident ticket is a good suggestion.

I have full permissions on the share and this ONLY started after sp3. If
you look on the web you'll see many people with the same issue but no real
solutions. (I have access 2003 11.8166.81.72 by the way)

Thanks for your post!
John

 

[John W. Vinson]

John,
Opening a maintenance incident ticket is a good suggestion.

I have full permissions on the share and this ONLY started after sp3. If
you look on the web you'll see many people with the same issue but no real
solutions. (I have access 2003 11.8166.81.72 by the way)

Just for interest - what version of Windows is running on the client and
server machines?

 

[John M]

client Windows XP Service Pack 2

Server - not a sever it's just a NAS

My deep down feeling is that it is some kind of software to hardware(driver)
issue

 

[David W. Fenton]

If you're sure
it's a bug, you may want to open a maintenance incident with
Microsoft tech support.

How does one do that? I've been discussing a problem in the
replication group, and it looks like a real bug, and I suggested he
open a ticket with MS, but I didn't know how to do that any more. Is
there a URL for it?

 

[David W. Fenton]

Server - not a sever it's just a NAS

Is it a non-Windows OS? If so, then you need to avoid it, as
non-Windows file systems are not necessarily compatible with Jet.

I would *never* store MDBs on anything but a genuine Windows file
system running under a Windows OS.

 

[Tony Toews [MVP]]

Microsoft needs to fix this bug!
When compacting a DB on a network drive the original file stays and it
creates the compacted one with the name db1. For whatever reason it does not
delete the old file and rename the new one.

This is a bug ever since SP3 for office. Fix it fix it fix it

Microsoft did. Description of the Access 2003 post-Service Pack 3
hotfix package: December 18, 2007
http://support.microsoft.com/kb/945674

One of the bullets states something very similar to your symptoms.

"When you run the Compact and Repair Database utility on an Access
2003 database that is saved on a Windows Server 2003 share, the
utility may silently fail. After the Compact and Repair Database
utility fails, an additional database file is saved in the same
location. For example, if the Compact and Repair Database utility is
run on a database that is named Db.mdb, a second database file that is
named Db1.mdb is saved."

Better yet maybe I'll petition my corporation to go with an open source
application instead.

Go for it. Trouble is there is no decent open source database tool.
There are for Word and Excel of course but not Access.

I'm so sick of microsoft not dealing with bugs that
they have created. We pay big money for their products and they leave us
hanging all the time.

Given that the above hotfix is dated Dec 2007 I don't think you can
say that in this case.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[John M]

Tony,
THANK YOU!!!!!! That was it.

Well they at least need to work on their search engine. I put in all these
key words and the hot fix did not come up. I wont argue on the open source
..... like I said in my previous post ... I was just trying to get someone to
something ... and it worked

David,
A NAS (Network Area Storage) it's hard drives sitting on the network.
They're formatted NTFS. No brains just disk.

 

[Ed Hansberry, MS-MVP/Mobile Devices]

Is it a non-Windows OS? If so, then you need to avoid it, as
non-Windows file systems are not necessarily compatible with Jet.

I would *never* store MDBs on anything but a genuine Windows file
system running under a Windows OS.

We have tons of Access databases on Novell shares and don't have
this issue.


__________
This was posted on Microsoft's microsoft.public.* newsgroup server. If you see this
on any other web page, it was stolen and used without permission.
See http://www.microsoft.com/communities/newsgroups/default.mspx

--
__________________________________________________________________________________
Ed Hansberry (Please do *NOT* email me. Post here for the benefit of all)
What is on my Pocket PC? http://www.ehansberry.com/
Microsoft MVP - Mobile Devices www.pocketpc.com
What is an MVP? -

 

[David W. Fenton]

We have tons of Access databases on Novell shares and don't have
this issue.

That was not always the case. I would never take the risk, though
(except read-only).

 

[David W. Fenton]

David,
A NAS (Network Area Storage) it's hard drives sitting on the
network. They're formatted NTFS. No brains just disk.

That's not the definition of a NAS. A NAS has an OS and is an
independent device that runs independent of a connection to any
other computer. If it's formatted NTFS and running a non-Windows OS,
that means it's even *less* reliable, as read/write access to NTFS
in Linux and other non-Windows OS is still experimental and not
recommended.

If it's just a hard drive connected to a computer on the network,
then, yes, of course, it's safe. But that's not a NAS.

 

[Tony Toews [MVP]]

Tony,
THANK YOU!!!!!! That was it.

You're quite welcome.

Well they at least need to work on their search engine. I put in all these
key words and the hot fix did not come up.

Yeah, I hear you on that one!

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/