Compacting Other Database with user level security...

[egapogi]

I got two MDBs one for frontend and another for backend..

In my frontend i have an option to compact the backend database after removing all necessary connection and closing all objects which refer to my backend MDB.

My backend mdb has user level security... Of course I have the valid user and password with me...

The online help does not specify on how to this with a secured database...

The following line gives me an error which sasys that I have no permission....etc..

DBEngine.CompactDatabase Name.MDB, Another.MDB

Anybody can help me....
thanks,

 

[ZylaWonder]

I think this is a good question!! It happened to me! My solution was to create a command button to compact my back-end database using DAO code. I created a workspace and assigned the user and password in code,(that way no one else could see them.) I tried ADO and it did not expose the same objects. DAO will allow you to create the workspace and identify the login, then perform the action (compact & repair). But be sure to close the workspace after you are done. There are some good articles in the microsoft knowledge base on the DAO subject.