Hi I have a database that I open with a password. There is no problem there but the minute i want to compact the database with a password it cant read the password. The passwords are the same from what I can see. Here is the code for opendatabase:

Set pDatabase = pWorkspace.OpenDataBase(App.Path & "\" & pDatabasName, False, False, ";PWD=password")

and here is the code i use to compact the database:

DBEngine.CompactDatabase App.Path & "\client.mdb", App.Path & "\client1.mdb", , ";PWD=password"

Now the passwords are exactly the same but compact database shows an error. If i dont have a password all the code works fine but I need to have a password on the database. Any ideas would be appreciated. Thanks in advance.

Mike


[This message has been edited by Spawny (edited 08-22-1999).]