Automatic compact and copy database

[Danu]

I have several databases which are sent out to a different server than where
they were developed. Only one of these databases makes a copy of itself when
the user closes the db. The user now has several copies of the same database,
i.e, db2, db3, etc.

I saw in a previous string that the issue could be the user's rights in the
directory where the db is located but there are several other dbs of the same
type there. It is just one that is duplicating itself.

Any ideas what may be causing this and how to change it?

Thanks in advance.

 

[John W. Vinson]

I have several databases which are sent out to a different server than where
they were developed. Only one of these databases makes a copy of itself when
the user closes the db. The user now has several copies of the same database,
i.e, db2, db3, etc.

I saw in a previous string that the issue could be the user's rights in the
directory where the db is located but there are several other dbs of the same
type there. It is just one that is duplicating itself.

Any ideas what may be causing this and how to change it?

Thanks in advance.

Two issues here. The one that's duplicating itself must have its "Compact on
Close" property set to True.

The other issue is that this user apparently does not have Rename or Delete
privileges on the folder containing the database.

If this is a frontend, with no tables just user interface and links, then by
all means turn off Compact on Close. If it's a unitary database I'd still turn
it off if you have some reliable process to make sure the database gets
compacted periodically; if you leave it on you'll need to give the user
sufficient privileges to create, modify, rename, and delete fields in the
folder.


John W. Vinson [MVP]

 

[Danu]

Thank you, John!! I'll check the db property and find out about the user's
privelages.

 

[Enrique Lòpez]

Thanks you for atention.

enrique lopez

 

[sergio]

hjigj