How to Compact Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nova - 30 Jun 2006 04:21 GMT

I set compact on close in my program. It works normally when used for
stanalone, After that I put this program in server, When extit program it
create new file eveytime. why?. How can compact database on network

Reply to this Message

Ken Snell (MVP) - 30 Jun 2006 05:28 GMT

Sounds like you don't have "delete" privileges for the folder where the file
is located on the server.

Signature

Ken Snell
<MS ACCESS MVP>

>I set compact on close in my program. It works normally when used for
> stanalone, After that I put this program in server, When extit program it
> create new file eveytime. why?. How can compact database on network

Reply to this Message

Nova - 30 Jun 2006 08:48 GMT

Network manager give me the right for all. I can delete and paste all file
on that folder but it stills cannot compact.

"Ken Snell (MVP)" เขียน:

> Sounds like you don't have "delete" privileges for the folder where the file
> is located on the server.
>
> >I set compact on close in my program. It works normally when used for
> > stanalone, After that I put this program in server, When extit program it
> > create new file eveytime. why?. How can compact database on network

Reply to this Message