Compact/Repair password protected backend

[jamie_b]

Hello,

I am using the following Module and Code and it works well:

http://www.access-programmers.co.uk/forums/showthread.php?t=228573


The only problem is that the backend is password protected.
So everytime I call...

Call CompactBE

...it prompts for the password.

I can ofcourse just remove the password from the backend but was hoping that I can "hardcode?" the password somewhere in the code.

Any help is appreciated.

Thanks,
Jamie.

 

[StarGrabber]

If you don't need a log file, try this:

DBEngine.CompactDatabase [I]PathAndNameOfSourceFile[/I], [I]PathAndNameOfDestinationFile[/I], , , ";pwd=[I]YourPassword[/I]"

 

[jamie_b]

If you don't need a log file, try this:

DBEngine.CompactDatabase [I]PathAndNameOfSourceFile[/I], [I]PathAndNameOfDestinationFile[/I], , , ";pwd=[I]YourPassword[/I]"

I don't mind the log file, and your solution seems to work fine. Thank you.
I will test it for a while and post back if there are any problems.

Thanks again.

 

[StarGrabber]

You're welcome. Good luck with your project!

 

[regikono]

If you don't need a log file, try this:

DBEngine.CompactDatabase [I]PathAndNameOfSourceFile[/I], [I]PathAndNameOfDestinationFile[/I], , , ";pwd=[I]YourPassword[/I]"

work!
Easy, simple, e best solution I found. Thank you!