Re: Odd Compact Behavior

"JohnC" wrote in message
news:b2b67$473bb182$40971c7d$2340@EVERESTKC.NET...
> Yes, I have delete permissions to the share. I am able to delete files
> in the shared folder.
> John
>
> "Rick Brandt" wrote in message
> news:Xsu_i.20684$Pv2.20384@newssvr23.news.prodigy.net...
>> JohnC wrote:
>>> For years, I have been able to have an Access .mdb file open, and be
>>> able to run the Compact/Repair routine. This would compact the file
>>> I had open at the time.
>>>
>>> For some reason, now Access (2003) is not compacting the current open
>>> database but it is making a new database with the db#.mdb naming
>>> scheme. It is an exact copy of my database in a compacted state.
>>> Nothing is done to the one I have open. I am doing this on a shared
>>> LAN file. Never had this problem before.
>>>
>>> Ideas? I'm sure it is something simple.
>>>
>>> John
>>
>> Do you have delete permissions to the share? The compact process makes a
>> new file, deletes your original, and then renames the new file. Without
>> delete perms you get stuck after step 1.
>>
>> --
>> Rick Brandt, Microsoft Access MVP
>> Email (as appropriate) to...
>> RBrandt at Hunter dot com
>>
>
>